Skip to content

Latest commit

 

History

1 Commit

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 

Repository files navigation

SQL templates

SQL models that rebuild source-system reports in your own warehouse.

Each integration ships both dialects:

  • weld/ — Weld transforms, {{raw.source.table}} refs
  • dbt/ — drop-in model files, {{ source() }} / {{ ref() }} refs

Integrations

Models
shopify/ sales over time, product sales over time, SKU cost per day, sales by product

The rest of the library is at weld.app/templates.

Notes

  • Written for BigQuery; adapt functions for other engines.
  • Files are named for what they do. The model name inside keeps its source prefix (shopify_sales_over_time) so table names stay unambiguous in one schema.
  • dbt/ folders are model files, not runnable projects. Copy them into your own project and repoint the refs.
  • Treat every model as unverified until you have reconciled it against the source system. Scope limits and validation status are in each file header.

About

SQL models that rebuild source-system reports in your own warehouse

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors