GPT

Dbt Data Quality Contract

models/silver/schema.yml version: 2 models: - name: silverorders description: "Cleansed, deduplicated order records. SLA: refreshed every 15 min." config: contract: enforced: true columns: - name: orderid dataty

Prompt text

Original English text. Replace placeholders with your own details.

# models/silver/schema.yml
version: 2

models:
 - name: silver_orders
 description: "Cleansed, deduplicated order records. SLA: refreshed every 15 min."
 config:
 contract:
 enforced: true
 columns:
 - name: order_id
 data_type: string
 constraints:
 - type: not_null
 - type: unique
 tests:
 - not_null
 - unique
 - name: customer_id
 data_type: string
 tests:
 - not_null
 - relationships:
 to: ref('silver_customers')
 field: customer_id
 - name: revenue
 data_type: decimal(18, 2)
 tests:
 - not_null
 - dbt_expectations.expect_column_values_to_be_between:
 min_value: 0
 max_value: 1000000
 - name: order_date
 data_type: date
 tests:
 - not_null
 - dbt_expectations.expect_column_values_to_be_between:
 min_value: "'2020-01-01'"
 max_value: "current_date"

 tests:
 - dbt_utils.recency:
 datepart: hour
 field: _updated_at
 interval: 1 # must have data within last hour

Source & attribution

Awesome Prompts · Awesome Prompts

Source-listed license: GPL-3.0. Prompt text is preserved; titles and previews may be shortened for display. Source examples are not NexGateHub test results.

View original source ↗ · Source credits & licenses

Explore more prompts →