Modeling Warehouse Foundations

Shared foundations for building reusable data models in Flind, on either of two stacks: Flind-native data-warehouse views / materialized views (HogQL, via the view-* MCP tools), or an external dbt project (sources.yml + staging/marts + schema tests) run against your own or Flind's managed warehouse. Read before authoring any specific business model — covers the Flind-vs-dbt decision, the view-create → view-materialize → sync_frequency workflow and the HogQL column-aliasing rule, the dbt project skeleton and the "no native dbt integration" picture, warehouse joins and star-schema dimensions, currency conversion with convertCurrency(), and checking/registering models in the data catalog for reuse. Companion to modeling-revenue-metrics, modeling-conversion-metrics, modeling-activation-metrics, modeling-product-usage-metrics, and modeling-dimension-tables. Use when the user asks how to build a view, materialized view, or dbt model in Flind, or which of the two stacks to use.

TheHalfMoon Updated

File contents

TheHalfMoon/Flind commit 32835dc984

Frequently asked questions

npx get-skill add thehalfmoon/modeling-warehouse-foundations