设置和引用源

1SELECT *
2FROM marketing_dataset.raw_ads

1version: 2
2
3sources:
4  - name: marketing
5    tables:
6      - name: raw_ads

1version: 2
2
3sources:
4  - name: marketing
5    tables:
6      - name: raw_ads
7  - name: design
8    tables:
9      - name: creatives
10      - name: logos

1SELECT *
2FROM {{ source('marketing', 'raw_ads') }}

1version: 2
2
3sources:
4  - name: marketing
5    database: external_project
6    dataset: raw_marketing
7    tables:
8      - name: raw_ads

1dbt ls --select source:raw

1dbt run --select source:raw+

1CREATE TABLE <your_dataset_name>.raw_orders AS (
2SELECT 1 AS order_id, "Monday" AS date
3UNION ALL
4SELECT 2 AS order_id, "Monday" AS date
5UNION ALL
6SELECT 3 AS order_id, "Tuesday" AS date
7UNION ALL
8SELECT 4 AS order_id, "Tuesday" AS date
9UNION ALL
10SELECT 5 AS order_id, "Tuesday" AS date
11)