Soda Core data quality scan

Steps

1. Install Soda Core with the appropriate data source package: pip install soda-core-{datasource} (e.g. soda-core-postgres or soda-core-bigquery).
2. Create a configuration YAML file (e.g. configuration.yml) with the data_source block defining connection details; use environment variable references for credentials.
3. Write a SodaCL checks file (e.g. checks.yml) defining checks on tables and columns, for example: checks for orders: - row_count > 0 - missing_count(email) = 0.
4. Run the scan from the command line: soda scan -d {datasource_name} -c configuration.yml checks.yml.
5. Review the scan output for PASS, FAIL, or WARN results per check; a non-zero exit code indicates at least one check failed, useful for CI/CD integration.