<div dir="ltr"><div>Snowflake now supports querying from Semantic Views.</div><div><br></div><div><br></div><div>-- Let's create a Semantic View</div><div>CREATE OR REPLACE SEMANTIC VIEW tpch_analysis_semantic_view</div><br>TABLES (<br>    customer AS SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.CUSTOMER PRIMARY KEY (c_custkey)<br>    , orders AS SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.ORDERS<br>  )<br><br>  RELATIONSHIPS (<br>    orders (o_custkey) REFERENCES customer<br>  )<br><br>  DIMENSIONS (<br>    customer.customer_name AS c_name<br>    , customer.customer_market_segment AS c_mktsegment<br>  )<br><br>  METRICS (<br>    customer.customer_count AS COUNT(c_custkey)<br>    , orders.order_count AS COUNT(o_orderkey)<br>    , orders.order_average_value AS AVG(orders.o_totalprice)<br>    , orders.order_total_value AS SUM(orders.o_totalprice)<br>    , orders.first_order_date as min(orders.o_orderdate)<br>    , orders.latest_order_date as max(orders.o_orderdate)<br><br>  )<br>;<br><div><br></div><div>-- Now query the semantic view</div><div><br></div>SELECT * FROM SEMANTIC_VIEW(<br>  tpch_analysis_semantic_view<br>  DIMENSIONS customer.customer_market_segment<br>  METRICS orders.order_count<br>    , orders.order_average_value<br>    , orders.order_total_value<br>    , orders.first_order_date<br>    , orders.latest_order_date<br><br><br>  );<br><br><br></div>