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 和 Notebook 的原生集成

在 Snowflake 内从实验到上线

内置治理、策略与可观测性

Snowflake Logo Icon

课程数据

课程数据查询显示前 10 行——date、rating、description、hotel_name、city、country 和 language

查询数据

课程数据列说明——date、rating、description、hotel_name、city、country 和 language——及其数据类型

Python 变量注入

在 SQL 查询中创建用于替换的 Python 变量

创建名为 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 入门