dbt-data-reliability/integration_tests/dbt_project/models/schema.yml at df232d4e18b355c7fb705d507bab3821bfca1c1c · elementary-data/dbt-data-reliability · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
version: 2

models:
  - name: customers
    description: This table has basic information about a customer, as well as some derived facts based on a customer's orders
    tests:
      - elementary.exposure_schema_validity:
          config:
            tags: [exposure_customers]

    columns:
      - name: id
        description: This is a unique identifier for a customer

      - name: name
        data_type: string
        description: Customer's name.

  - name: orders
    description: This table has basic information about orders, as well as some derived facts based on payments

    tests:
      - elementary.exposure_schema_validity:
          config:
            tags: [exposure_orders]

    columns:
      - name: order_id
        description: This is a unique identifier for an order

      - name: customer_id
        description: Foreign key to the customers table

      - name: order_date
        description: Date (UTC) that the order was placed

      - name: amount
        description: Total amount (AUD) of the order