Orders Table
Orders Table
Assurez une cohérence irréprochable entre tous vos produits de données
Assurez une cohérence irréprochable entre tous vos produits de données
Ensure Retail Orders data is fresh, complete, and reliable before it’s used downstream.
Data contract description
This data contract enforces schema stability, a 24-hour freshness SLA, required identifiers and timestamps, prevents missing or invalid values, and applies controlled formats for currencies, payment methods, and country codes. Together, these checks prevent incomplete or invalid orders from breaking analytics, dashboards, or revenue reporting.
retail_orders_data_contract.yml
datasetchecks: - schema: {} - freshness: column: created_at threshold: unit: hour must_be_less_than_or_equal: 24
columns: - name: order_id data_type: string checks: - missing: name: No missing value - name: product_id data_type: string checks: - missing: name: No missing values - name: customer_id data_type: string checks: - missing: name: No missing values - name: order_quantity data_type: integer checks: - missing: - invalid: name: Positive quantity valid_min: 1 - name: discount data_type: float checks: - invalid: name: Positive quantity valid_min: 1 - name: discount_currency data_type: string checks: - invalid: name: Allowed currency is USD valid_values: - usd - name: billing_address data_type: string checks: - missing: - name: shipping_address data_type: string checks: - missing: - name: payment_method data_type: string checks: - missing: - invalid: name: Allowed payment methods valid_values: - cash - credit_card - transfer - name: order_date data_type: dateTime checks: - missing: - name: ship_date data_type: dateTime checks: - missing: - name: country_code data_type: string checks: - missing: - invalid: name: Two-letter country code valid_format: regex: ^[A-Za-z]{2}$ name: Exactly two letters - name: total_order_value data_type: float checks: - missing: - name: created_at data_type: dateTime checks: - missing
Data contract description
This data contract enforces schema stability, a 24-hour freshness SLA, required identifiers and timestamps, prevents missing or invalid values, and applies controlled formats for currencies, payment methods, and country codes. Together, these checks prevent incomplete or invalid orders from breaking analytics, dashboards, or revenue reporting.
retail_orders_data_contract.yml
datasetchecks: - schema: {} - freshness: column: created_at threshold: unit: hour must_be_less_than_or_equal: 24
columns: - name: order_id data_type: string checks: - missing: name: No missing value - name: product_id data_type: string checks: - missing: name: No missing values - name: customer_id data_type: string checks: - missing: name: No missing values - name: order_quantity data_type: integer checks: - missing: - invalid: name: Positive quantity valid_min: 1 - name: discount data_type: float checks: - invalid: name: Positive quantity valid_min: 1 - name: discount_currency data_type: string checks: - invalid: name: Allowed currency is USD valid_values: - usd - name: billing_address data_type: string checks: - missing: - name: shipping_address data_type: string checks: - missing: - name: payment_method data_type: string checks: - missing: - invalid: name: Allowed payment methods valid_values: - cash - credit_card - transfer - name: order_date data_type: dateTime checks: - missing: - name: ship_date data_type: dateTime checks: - missing: - name: country_code data_type: string checks: - missing: - invalid: name: Two-letter country code valid_format: regex: ^[A-Za-z]{2}$ name: Exactly two letters - name: total_order_value data_type: float checks: - missing: - name: created_at data_type: dateTime checks: - missing
Data contract description
This data contract enforces schema stability, a 24-hour freshness SLA, required identifiers and timestamps, prevents missing or invalid values, and applies controlled formats for currencies, payment methods, and country codes. Together, these checks prevent incomplete or invalid orders from breaking analytics, dashboards, or revenue reporting.
retail_orders_data_contract.yml
datasetchecks: - schema: {} - freshness: column: created_at threshold: unit: hour must_be_less_than_or_equal: 24
columns: - name: order_id data_type: string checks: - missing: name: No missing value - name: product_id data_type: string checks: - missing: name: No missing values - name: customer_id data_type: string checks: - missing: name: No missing values - name: order_quantity data_type: integer checks: - missing: - invalid: name: Positive quantity valid_min: 1 - name: discount data_type: float checks: - invalid: name: Positive quantity valid_min: 1 - name: discount_currency data_type: string checks: - invalid: name: Allowed currency is USD valid_values: - usd - name: billing_address data_type: string checks: - missing: - name: shipping_address data_type: string checks: - missing: - name: payment_method data_type: string checks: - missing: - invalid: name: Allowed payment methods valid_values: - cash - credit_card - transfer - name: order_date data_type: dateTime checks: - missing: - name: ship_date data_type: dateTime checks: - missing: - name: country_code data_type: string checks: - missing: - invalid: name: Two-letter country code valid_format: regex: ^[A-Za-z]{2}$ name: Exactly two letters - name: total_order_value data_type: float checks: - missing: - name: created_at data_type: dateTime checks: - missing
How to Enforce Data Contracts with Soda
Embed data quality through data contracts at any point in your pipeline.
Embed data quality through data contracts at any point in your pipeline.
# pip install soda-{data source} for other data sources
# pip install soda-{data source} for other data sources
pip install soda-postgres
pip install soda-postgres
# verify the contract locally against a data source
# verify the contract locally against a data source
soda contract verify -c contract.yml -ds ds_config.yml
soda contract verify -c contract.yml -ds ds_config.yml
# publish and schedule the contract with Soda Cloud
# publish and schedule the contract with Soda Cloud
soda contract publish -c contract.yml -sc sc_config.yml
soda contract publish -c contract.yml -sc sc_config.yml
Check out the CLI documentation to learn more.
Check out the CLI documentation to learn more.
How to Automatically Create Data Contracts.
In one Click.
Automatically write and publish data contracts using Soda's AI-powered data contract copilot.
Qualité des données IA basée sur la recherche
Nos recherches ont été publiées dans des revues et conférences de renom, telles que NeurIPs, JAIR et ACML. Les mêmes lieux qui ont fait progresser les fondations de GPT et de l'IA moderne.
Qualité des données IA basée sur la recherche
Nos recherches ont été publiées dans des revues et conférences de renom, telles que NeurIPs, JAIR et ACML. Les mêmes lieux qui ont fait progresser les fondations de GPT et de l'IA moderne.
Qualité des données IA basée sur la recherche
Nos recherches ont été publiées dans des revues et conférences de renom, telles que NeurIPs, JAIR et ACML. Les mêmes lieux qui ont fait progresser les fondations de GPT et de l'IA moderne.
Explore more data contract templates
One new data contract template every day, across industries and use cases
4,4 sur 5
Commencez à faire confiance à vos données. Aujourd'hui.
Trouvez, comprenez et corrigez tout problème de qualité des données en quelques secondes.
Du niveau de la table au niveau des enregistrements.
Adopté par
4,4 sur 5
Commencez à faire confiance à vos données. Aujourd'hui.
Trouvez, comprenez et corrigez tout problème de qualité des données en quelques secondes.
Du niveau de la table au niveau des enregistrements.
Adopté par
Solutions
4,4 sur 5
Commencez à faire confiance à vos données. Aujourd'hui.
Trouvez, comprenez et corrigez tout problème de qualité des données en quelques secondes.
Du niveau de la table au niveau des enregistrements.
Adopté par
Solutions
Company