One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill soda-core
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: soda-core
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/skills/soda_core
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill soda-core

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Data pipelines often silently produce bad, incomplete, stale, or schema-violating data, and teams need a reliable way to detect and stop downstream failures early.

Core Features & Use Cases

  • SodaCL data quality checks: Define validations for nulls (missing), invalid values, duplicates, freshness/SLA, schema expectations, referential integrity, and numeric anomaly metrics.
  • Adapter-based configuration: Run the same checks against PostgreSQL, Spark, ClickHouse, Trino, and BigQuery using a configuration.yml data source.
  • Operational integration: Execute scans via CLI or embed them as an Airflow task; optionally complement or ingest with dbt workflows.

Quick Start

Use the soda-core skill to scan silver/orders with SodaCL checks by running: soda scan -d postgres_prod -c soda/configuration.yml soda/checks/silver_orders.yml

Frequently Asked Questions about soda-core

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I add data quality checks to my ETL pipeline to catch bad data?

You can add data quality checks to your ETL pipeline by running SodaCL definitions through a scan command, which evaluates your data sources for missing values, duplicates, and schema violations, returning pass, warn, or fail statuses.

Can I use SodaCL to validate data freshness and schema expectations in dbt workflows?

Yes, you can use SodaCL to validate data freshness and schema expectations in dbt workflows by executing soda scan commands alongside your dbt runs, allowing you to define SLA checks and schema validations directly in YAML.

Does SodaCL support running data quality gates in Airflow?

Yes, SodaCL supports running data quality gates in Airflow. You can embed the soda scan execution as a task within your Airflow DAGs to automatically halt downstream processes if checks fail.

What data sources can I run SodaCL data quality checks against?

You can run SodaCL data quality checks against multiple data sources including PostgreSQL, Spark, ClickHouse, Trino, and BigQuery by configuring a YAML data source file for your specific adapter.

How do I check for duplicate and invalid records in SQL tables before publishing?

To check for duplicate and invalid records in SQL tables before publishing, define SodaCL checks in a YAML file and execute a soda scan, which will evaluate your custom SQL metrics and referential integrity rules.

What is the best way to set up data quality gates for batch ETL partitions?

The best way to set up data quality gates for batch ETL partitions is to define SodaCL checks in a YAML file and run the soda scan command targeting your specific partitions to return pass, warn, or fail statuses.