DuckDB Semantic Views
Overview
Tutorials
Getting Started
Install the extension and run your first query in 5 minutes
Multi-Table Semantic Views
Model multi-table schemas with relationships
How-To Guides
FACTS
Define reusable row-level expressions referenced in metrics
Derived Metrics
Compose metrics from other metrics using arithmetic
Role-Playing Dimensions
Join the same table multiple times with distinct aliases
Fan Traps
Detect and resolve aggregation inflation from one-to-many joins
Data Sources
Connect CSV, Parquet, Iceberg, and database tables to semantic views
Explanation
Semantic Views vs Regular Views
What semantic views add beyond standard SQL views
Snowflake Comparison
Feature comparison with Snowflake SQL DDL semantic views
Reference
/
Index