Problem: There are known issues on Soda SQL when using pip version 19.
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
Problem: Soda SQL scans produce errors in the CLI.
Solution: Check your
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.
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.