[Wranglers] Snowflake now support querying from Semantic Views

[Ali, Saqib]

Another post on Semantic Views:
https://forum.edu.scot/t/anatomy-of-a-semantic-view/39


On Thu, Jun 26, 2025 at 5:44 AM Ali, Saqib <docbook.xml at gmail.com> wrote:

> A blogpost on how to create a Snowflake Semantic View to monitor the
> Snowflake Credits consumed by recurrent queries:
>
> https://forum.edu.scot/t/semantic-view-to-monitor-the-snowflake-credit-spend/37
>
>
>
> On Sun, Jun 15, 2025 at 9:01 PM Ali, Saqib <docbook.xml at gmail.com> wrote:
>
>> Here is a blogpost how Semantic Views ensures the aggregations are being
>> calculated at the correct grain:
>> https://forum.edu.scot/t/semantic-views-and-grain-of-the-data/35
>>
>> Thanks,
>> Saqib
>>
>> On Wed, Jun 11, 2025 at 10:02 AM Ali, Saqib <docbook.xml at gmail.com>
>> wrote:
>>
>>> Another detailed blogpost on Semantic Views by Chanin Nantasenamat:
>>>
>>> https://medium.com/snowflake/getting-started-with-snowflake-semantic-view-7eced29abe6f
>>>
>>> On Wed, Jun 11, 2025 at 5:34 AM Ali, Saqib <docbook.xml at gmail.com>
>>> wrote:
>>>
>>>> Here is a blogpost on using Semantic Views for Aggregate-sensitive
>>>> Metrics:
>>>>
>>>> https://forum.edu.scot/t/using-semantic-views-for-aggregate-sensitive-metrics/34
>>>>
>>>>
>>>>
>>>> On Wed, Jun 4, 2025 at 7:23 AM Ali, Saqib <docbook.xml at gmail.com>
>>>> wrote:
>>>>
>>>>> Snowflake Quick Start guide for Semantic Views:
>>>>>
>>>>> https://quickstarts.snowflake.com/guide/snowflake-semantic-view/index.html#0
>>>>>
>>>>> On Tue, Jun 3, 2025 at 11:58 AM Ali, Saqib <docbook.xml at gmail.com>
>>>>> wrote:
>>>>>
>>>>>> here is the Snowflake official documentation on Semantic Views:
>>>>>> https://snowflake.com/en/engineering-blog/native-semantic-views-ai-bi/
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Tue, Jun 3, 2025 at 9:50 AM Ali, Saqib <docbook.xml at gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> 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......
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Jun 3, 2025 at 6:02 AM Ali, Saqib <docbook.xml at gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Snowflake now supports querying from Semantic Views.
>>>>>>>>
>>>>>>>>
>>>>>>>> -- Let's create a Semantic View
>>>>>>>> CREATE OR REPLACE SEMANTIC VIEW tpch_analysis_semantic_view
>>>>>>>>
>>>>>>>> TABLES (
>>>>>>>>     customer AS SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.CUSTOMER PRIMARY KEY
>>>>>>>> (c_custkey)
>>>>>>>>     , orders AS SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.ORDERS
>>>>>>>>   )
>>>>>>>>
>>>>>>>>   RELATIONSHIPS (
>>>>>>>>     orders (o_custkey) REFERENCES customer
>>>>>>>>   )
>>>>>>>>
>>>>>>>>   DIMENSIONS (
>>>>>>>>     customer.customer_name AS c_name
>>>>>>>>     , customer.customer_market_segment AS c_mktsegment
>>>>>>>>   )
>>>>>>>>
>>>>>>>>   METRICS (
>>>>>>>>     customer.customer_count AS COUNT(c_custkey)
>>>>>>>>     , orders.order_count AS COUNT(o_orderkey)
>>>>>>>>     , orders.order_average_value AS AVG(orders.o_totalprice)
>>>>>>>>     , orders.order_total_value AS SUM(orders.o_totalprice)
>>>>>>>>     , orders.first_order_date as min(orders.o_orderdate)
>>>>>>>>     , orders.latest_order_date as max(orders.o_orderdate)
>>>>>>>>
>>>>>>>>   )
>>>>>>>> ;
>>>>>>>>
>>>>>>>> -- Now query the semantic view
>>>>>>>>
>>>>>>>> SELECT * FROM SEMANTIC_VIEW(
>>>>>>>>   tpch_analysis_semantic_view
>>>>>>>>   DIMENSIONS customer.customer_market_segment
>>>>>>>>   METRICS orders.order_count
>>>>>>>>     , orders.order_average_value
>>>>>>>>     , orders.order_total_value
>>>>>>>>     , orders.first_order_date
>>>>>>>>     , orders.latest_order_date
>>>>>>>>
>>>>>>>>
>>>>>>>>   );
>>>>>>>>
>>>>>>>>
>>>>>>>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20250714/f3e121c3/attachment.htm>