The corpus
Analytical modeling logic from real production warehouses, organized as reusable Patterns. These are the numbers behind the Pattern library.
340K
model files
51M
lines of analytical code
5.0M
dimensions and measures
1.0M
modeled joins
300M
code tokens
170+
industry domains
Language distribution
dbt 150
SQL 150
LKML 200
LookML 100
Quality signals
98%
Patterns with dimensions and measures
100%
Patterns with a business definition
54%
SQL Blocks that parse
Industry coverage
Advertising
Advertising automotive
Advertising email
Advertising technology
Agriculture wine
Analytics marketing
Analytics shopping
App event sharing
App loyalty
Automotive marketplace
Call center
Car manufacture
Charity
Clothing app
Cloud computing
Club subscription
Communications platform
Consulting it
Content sharing
Coupon platform
Crowdfunding
Crowdfunding education
Crowdfunding platform
Data analytics
Dating platform
Delivery alcohol
Delivery app
Delivery marketplace
Delivery service
Design marketplace
Developer apps
Digital journalism
Ecommerce
Ecommerce analytics
Ecommerce beauty
Ecommerce beverage
Ecommerce discount
Ecommerce eyewear
Ecommerce fashion
Ecommerce fashion plus
Ecommerce florist
Ecommerce furniture
Ecommerce grooming
Ecommerce luxury
Ecommerce luxury consign
Ecommerce marketplace
Ecommerce mattresses
Ecommerce mobile used
Ecommerce supplies
Ecommerce ticketing
Ecommerce window treatments
Edtech
Education kids
Education language
Education university
Eldercare content
Electronics cloud storage
Electronics kids
Electronics wifi
Energy management
Entertainment tech
Financial services
Fintech analytics
Fintech api
Fintech consulting
Fintech crowdfunding
Fintech lending
Fintech payments
Fitness gaming
Freelance marketplace
Game development
Gaming fantasy
Genomics health services
Health marketing
Healthcare analytics
Impossibleventures
Insurance brokerage
Insurance tech
Insurance vehicle
Internet security
Loyalty enterprise
Manufacturing sanitary
Marketing analytics
Marketing digital
Marketing enterprise
Marketing platform
Marketplace automotive
Media engagement
Media large poc
Media publishing
Medical device
Mobile ticketing
Nutrition coaching
Parking reservations
Real estate marketplace
Religious org
Retail gastronomy
Saas analytics
Saas cicd
Saas cloud infrastructure
Saas containerization
Saas content marketing
Saas crm
Saas crm life sciences
Saas ecosystem
Saas experience management
Saas gaming platform
Saas hospitality
Saas infrastructure
Saas legislation
Saas recruitment
Saas search
Saas translation
Saas usability testing
Saas video platform
Service marketplace
Service reviews marketplace
Social greetings
Social network sport
Social platform
Social shopping
Software real estate
Streaming cinema
Subscription fitness
Subscription jewelry
Subscription reading
Telecom services
Telemedicine service
Travel app
Venture accelerator
Venture capital
Video editing
Virtual call center