Link Search Menu Expand Document

Troubleshoot

Install and upgrade

Problem: There are known issues on Soda SQL when using pip version 19.
Solution: Upgrade pip to version 20 or greater using the following command:

$ pip install --upgrade pip


Problem: Upgrading Soda SQL does not seem to work.
Solution: Run the following command to skip your local cache when upgrading your Soda SQL version:

$ pip install --upgrade --no-cache-dir soda-sql-yourdatawarehouse


Scans and tests

Problem: Soda SQL scans produce errors in the CLI.
Solution: Check your warehouse.yml, env_vars.yml, and scan YAML files for proper spacing, indentation, and verbiage. See Warehouse YAML and Scan YAML.

Problem: When I run a scan, I get this error.

UnicodeEncodeError: 'latin-1' codec can't encode character '\u20ac' in position 431: ordinal not in range(256)

Solution: Soda SQL does not support scans of tables using Latin-1 encoding. Adjust the tables to UTF-8 encoding to run a scan.

Warehouse connections

Problem: I get errors in the CLI when I run soda analyze on my MS SQL server warehouse.
Solution: Connecting Soda SQL to MS SQL servers is still in experimental phase. You may encounter errors before this warehouse connection type is stabilized.