Fix analyze error message

[tombaeyens]

https://soda-community.slack.com/archives/C01HYL8V64C/p1617727771108800

Hi, I'm new to soda community. I recently installed on a dev server the CLI and configured a redshift host to run soda analyze, but I get the following error while running it:

$ soda analyze
 | 2.0.0b26
 | Analyzing warehouse.yml ...
 | Querying warehouse for tables
 | Directory tables already exists
 | Exception: 'NoneType' object has no attribute 'lower'
Traceback (most recent call last):
 File "/usr/local/airflow/.local/lib/python3.8/site-packages/sodasql/cli/cli.py", line 237, in analyze
  tables_metadata_query = dialect.sql_tables_metadata_query()
 File "/usr/local/airflow/.local/lib/python3.8/site-packages/sodasql/dialects/postgres_dialect.py", line 50, in sql_tables_metadata_query
  return (f"SELECT table_name \n"
AttributeError: 'NoneType' object has no attribute 'lower'

[vijaykiran]

More context - this happens when the schema property isn't set in warehouse.yml.

[vijaykiran]

Related sodadata/soda-core#749