Staged customers data
- File
- models/staging/stg_customers.sql
Lineage
Upstream 1
- source raw.customers
Downstream 1
- model customers
Columns 4
| Column | From | Used by |
|---|---|---|
| customer_id | raw.customers.id, raw.customers.customer_id | customers.customer_id |
| first_name | raw.customers.first_name | customers.first_name |
| last_name | raw.customers.last_name | customers.last_name |
| raw.customers.email | customers.email |
SQL
SELECT
id as customer_id,
first_name,
last_name,
email
FROM {{ source('raw', 'customers') }}