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.