Reusable Patterns for analytical code

Browse real modeling logic from a large corpus of warehouse SQL, LookML, and dbt. Each Pattern shows its source, its assumptions, and a trust label before you adapt it.

340K

model files

51M

lines of analytical code

5.0M

dimensions and measures

1.0M

modeled joins

Language mix of 600 Patterns

dbt 150 SQL 150 LKML 200 LookML 100

Recent activity

Freya Pappas published Is Order Items LKML inferred today

Caleb Bauer published Hr Looker Training Set dbt inferred today

Elena Rossi published Active Within Period Over Time SQL source-preserved 1d ago

Kofi Kovac published Actual dbt inferred 2d ago

Sofia Haugen published Labor Hour LKML inferred 3d ago

Ivy Dubois published Event Order Date Fperformances SQL source-preserved 3d ago

Leah Sharma published A R SQL source-preserved 4d ago

Lucas Dubois published Action Alert Templates LookML source-preserved 4d ago

Victor Virtanen published Customer Booking Facts SQL source-preserved 5d ago

Hana Walsh published User Historical Purchase Facts SQL source-preserved 6d ago

Victor Silva published Eob Summary SQL source-preserved 6d ago

Nadia Eriksen published People LKML inferred 6d ago

Freya Pappas published Daysum LKML inferred 1w ago

Caleb Chukwu published User Engagement dbt inferred 1w ago

Victor Virtanen published Final Allowed SQL source-preserved 1w ago

Lena Adeyemi published Audience Houseconstructionyear Distribution Conversions SQL source-preserved 1w ago

Pablo Eriksen published Delivery Distance SQL source-preserved 1w ago

Arjun Haddad published Inventory Units LookML source-preserved 1w ago

Elena Reyes published Claim Line LKML inferred 2w ago

Iris Virtanen published Participations Duration dbt inferred 2w ago

Featured Patterns

LKML Service marketplace

Promotions

Promotions model for service marketplace.

inferred

Maya Okafor 4,038 views, 38 adaptations

dbt Saas crm life sciences

Engagement Facts

Engagement Facts model for saas crm life sciences.

inferred

Anika Keller 4,008 views, 88 adaptations

SQL Mobile ticketing

Promoters With Users

Promoters With Users model for mobile ticketing.

source-preserved

Lucas Walsh 4,005 views, 45 adaptations

LKML Retail gastronomy

Payroll Check

Payroll Check model for retail gastronomy.

inferred

Aria Said 4,004 views, 4 adaptations

dbt Insurance vehicle

Sessions

Sessions model for insurance vehicle.

inferred

Tariq Silva 4,000 views, 80 adaptations

SQL Delivery alcohol

Delivery Distance

Delivery Distance model for delivery alcohol.

source-preserved

Pablo Eriksen 3,971 views, 91 adaptations

LookML Ecommerce luxury consign

Variants

Variants model for ecommerce luxury consign.

source-preserved

Maya Mehta 3,970 views, 10 adaptations

LKML Service marketplace

Profile Metadata

Profile Metadata model for service marketplace.

inferred

Liam Nguyen 3,967 views, 47 adaptations