[Wranglers] Snowflake now support querying from Semantic Views

[Ali, Saqib]

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/20250611/c6694ffc/attachment.htm>