<div dir="ltr">Another post on Semantic Views:<br><div><a href="https://forum.edu.scot/t/anatomy-of-a-semantic-view/39">https://forum.edu.scot/t/anatomy-of-a-semantic-view/39</a></div><div><br></div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Thu, Jun 26, 2025 at 5:44 AM Ali, Saqib <<a href="mailto:docbook.xml@gmail.com">docbook.xml@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">A blogpost on how to create a Snowflake Semantic View to monitor the Snowflake Credits consumed by recurrent queries:<br><a href="https://forum.edu.scot/t/semantic-view-to-monitor-the-snowflake-credit-spend/37" target="_blank">https://forum.edu.scot/t/semantic-view-to-monitor-the-snowflake-credit-spend/37</a><div><span style="font-size:12.8px"><br></span></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, Jun 15, 2025 at 9:01 PM Ali, Saqib <<a href="mailto:docbook.xml@gmail.com" target="_blank">docbook.xml@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Here is a blogpost how Semantic Views ensures the aggregations are being calculated at the correct grain:<br><div><a href="https://forum.edu.scot/t/semantic-views-and-grain-of-the-data/35" target="_blank">https://forum.edu.scot/t/semantic-views-and-grain-of-the-data/35</a></div><div><br></div><div>Thanks,</div><div>Saqib</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jun 11, 2025 at 10:02 AM Ali, Saqib <<a href="mailto:docbook.xml@gmail.com" target="_blank">docbook.xml@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Another detailed blogpost on Semantic Views by Chanin Nantasenamat:<br><a href="https://medium.com/snowflake/getting-started-with-snowflake-semantic-view-7eced29abe6f" target="_blank">https://medium.com/snowflake/getting-started-with-snowflake-semantic-view-7eced29abe6f</a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jun 11, 2025 at 5:34 AM Ali, Saqib <<a href="mailto:docbook.xml@gmail.com" target="_blank">docbook.xml@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Here is a blogpost on using Semantic Views for Aggregate-sensitive Metrics:<br><a href="https://forum.edu.scot/t/using-semantic-views-for-aggregate-sensitive-metrics/34" target="_blank">https://forum.edu.scot/t/using-semantic-views-for-aggregate-sensitive-metrics/34</a><div><span style="font-size:12.8px"><br></span></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jun 4, 2025 at 7:23 AM Ali, Saqib <<a href="mailto:docbook.xml@gmail.com" target="_blank">docbook.xml@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Snowflake Quick Start guide for Semantic Views:<br><a href="https://quickstarts.snowflake.com/guide/snowflake-semantic-view/index.html#0" target="_blank">https://quickstarts.snowflake.com/guide/snowflake-semantic-view/index.html#0</a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jun 3, 2025 at 11:58 AM Ali, Saqib <<a href="mailto:docbook.xml@gmail.com" target="_blank">docbook.xml@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">here is the Snowflake official documentation on Semantic Views:<br><a href="https://snowflake.com/en/engineering-blog/native-semantic-views-ai-bi/" target="_blank">https://snowflake.com/en/engineering-blog/native-semantic-views-ai-bi/</a><div><span style="font-size:12.8px"><br></span></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jun 3, 2025 at 9:50 AM Ali, Saqib <<a href="mailto:docbook.xml@gmail.com" target="_blank">docbook.xml@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">One thing I noticed is that while Snowflake lets you define PRIMARY KEY on the TABLE in a Semantic View, it does not enforce the Primary Key constraint. This could potentially lead to incorrect metric calculations in the Semantic View. Hopefully Snowflake fixes this soon......<div><span style="font-size:12.8px"><br></span></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jun 3, 2025 at 6:02 AM Ali, Saqib <<a href="mailto:docbook.xml@gmail.com" target="_blank">docbook.xml@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><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>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>