How-To Guides¶
Goal-oriented guides for specific tasks with DuckDB Semantic Views.
How to Use FACTS for Reusable Row-Level Logic — Define reusable row-level expressions that can be referenced inside metric aggregations.
How to Compose Metrics with Derived Metrics — Compose metrics from other metrics using arithmetic without repeating aggregate logic.
How to Model Role-Playing Dimensions — Join the same physical table multiple times under different aliases for distinct relationships.
How to Understand and Avoid Fan Traps — Understand, detect, and resolve fan traps that inflate aggregation results in multi-table views.
How to Use Different Data Sources — Connect semantic views to CSV, Parquet, Iceberg, and database tables.