Skip to main content
After a schema refresh imports your semantic views, each one is a topic you can query like any other. This page covers where the topics appear and what to expect when querying them.

​
Where the topics appear

Imported topics carry a Snowflake mark in the topic picker, field browser, and model IDE; hover it to see the fully qualified semantic view name. In the IDE file browser they sit in a Snowflake Semantic Views folder. Set a group_label to move one into a group of your own.

​
Querying a semantic view topic

In a workbook, pick the topic and select fields as in any other topic. Filtered measures, level-of-detail calculations, dynamic top N, column totals, period-over-period comparisons, pivots, and composite topics all work. Metrics use symmetric aggregates keyed on the PRIMARY KEY of the logical table the metric reads from, so a metric queried across a one-to-many join counts each row once.

​
Troubleshooting

Symmetric aggregates key on the logical table’s PRIMARY KEY. Check that the logical table in the semantic view declares one, then run a schema refresh.

​
Next steps