Snowflake Cortex 與 Notebooks 入門

Snowflake 生成式 AI 入門

James Cha-Earley

Senior Developer Advocate, Snowflake

認識你的講師！

James Cha-Earley

Snowflake 資深開發者倡議者

講師照片

Snowflake Cortex

Snowflake Cortex AI

觸手可用的生產等級 AI

¹ Image source: https://www.snowflake.com/en/product/features/cortex/

Cortex AI

原生整合 SQL、Python 與 notebooks

在 Snowflake 內從實驗到上線

內建治理、政策與可觀測性

Snowflake Logo Icon

課程資料

查詢課程資料的前 10 列：date、rating、description、hotel_name、city、country 與 language

查詢資料

課程資料欄位與型別說明：date、rating、description、hotel_name、city、country、language

Python 變數注入

建立一個 Python 變數，用於在 SQL 查詢中替換

建立名為 target_location 的 Python 變數並指定 Cancun

Python 變數注入

將 Python 變數注入 SQL 查詢

摘要文字

from snowflake.cortex import summarize


review = """
I was very impressed with this hotel, especially the service.
They make you feel special and you feel like everything is possible. 
Special shout out to the Kidz Club staff. 
Our daughter is very picky and for the first time, she begged to go back there. 
They have a great supervision and they let the kids do fun activities
such as cooking classes and crafting. 
The food was really good (buffet offered a different choice everyday). 
The all-inclusive program is really worth the price, and the beach was beautiful!
"""

摘要文字

result = summarize(text=review)

print(result)

The hotel delivered excellent service with outstanding Kidz Club staff who engaged 
even picky children through supervised activities. The daily buffet offered good
variety, and the all-inclusive program plus beautiful beach provided great value.

在 SQL 儲存格使用 Cortex

在 SQL 儲存格中執行 summarize

在 SQL 儲存格執行時不需匯入

需要串接多個函式時，使用 Python 儲存格

一起來練習吧！

Snowflake 生成式 AI 入門