Subchapter 99.2

Dim Customer

Dim Customer · Modeling Revenue Metrics · PostHog/skills · Skills Docs

references/dbt/dim_customer.sql

SQL10 lines324 B

1-- Customer dimension, one row per customer. Analogue of PostHog's managed customer view.
2{{ config(materialized='table') }}
3
4select
5    id            as customer_id,
6    name          as customer_name,
7    email,
8    address_country as country,
9    created::date as first_seen_date
10from {{ source('stripe', 'customers') }}

dim_customer.sql on GitHub