CONNECTOR · SNOWFLAKE
Snowflake — Our default warehouse. dbt-first marts, role-based access, automatic suspend on idle.
CONNECTOR · SNOWFLAKE
Snowflake
Our default warehouse. dbt-first marts, role-based access, automatic suspend on idle.
- categoryDestination · Warehouse
- freshness targetSub-minute compute spin-up; freshness governed per source
- auth modelKey-pair via the dbt service role. SCIM-provisioned humans.
- sync modeMaterialized via dbt: tables, incremental, snapshots.
TABLES SYNCED
Staging / intermediate / marts layers. Per-mart owner enforced via dbt project metadata.
SCHEMA · SAMPLE
schema.sqlSQL
CREATE TABLE marts.fct_revenue (
period DATE,
revenue NUMERIC(18,2),
customers BIGINT
)
CLUSTER BY (period);QUERY · SAMPLE
query.sqlSQL
SELECT period, revenue
FROM marts.fct_revenue
WHERE period >= DATEADD(month, -12, CURRENT_DATE)
ORDER BY period;OPS NOTES
Cost discipline: query tags on every dbt run, an X-Small for staging, X-Large only for marts on a tight schedule.
Wire a real pipeline to your warehouse
30-min stack review. We come back with a scoped plan, an owner, and a freshness contract. No SDR, no slide deck.