Einführung in Snowflake Cortex und Notebooks

Einführung in Generative KI in Snowflake

James Cha-Earley

Senior Developer Advocate, Snowflake

Lern deine Lehrkraft kennen!

 

$$

James Cha-Earley

  • Senior Developer Advocate bei Snowflake

 

Foto der Lehrkraft

Einführung in Generative KI in Snowflake

Snowflake Cortex

Snowflake Cortex AI

  • Produktionsreife KI stets griffbereit
1 Image source: https://www.snowflake.com/en/product/features/cortex/
Einführung in Generative KI in Snowflake

Cortex AI

$$

  • Nahtlose Integration in SQL, Python und Notebooks

$$

  • Von Experiment bis Produktion in Snowflake

$$

  • Integrierte Governance, Richtlinien und Observability

Snowflake-Logo-Icon

Einführung in Generative KI in Snowflake

Kursdaten

Abfrage der Kursdaten mit den ersten 10 Zeilen – date, rating, description, hotel_name, city, country und language

Einführung in Generative KI in Snowflake

Daten abfragen

Beschreibung der Kursdaten mit Spalten – date, rating, description, hotel_name, city, country und language – und Datentypen

Einführung in Generative KI in Snowflake

Python-Variableninjektion

  • Erstelle eine Python-Variable zur Verwendung in einer SQL-Abfrage

Erstellen einer Python-Variable namens target_location mit dem Wert Cancun

Einführung in Generative KI in Snowflake

Python-Variableninjektion

Eine Python-Variable in eine SQL-Abfrage injizieren

Einführung in Generative KI in Snowflake

Text zusammenfassen

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!
"""
Einführung in Generative KI in Snowflake

Text zusammenfassen

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.
Einführung in Generative KI in Snowflake

Cortex in SQL-Zellen

Ausführen von summarize in der SQL-Zelle

$$

  • Keine Imports nötig in SQL-Zellen

$$

  • Verwende Python-Zellen, um mehrere Funktionen zu verketten
Einführung in Generative KI in Snowflake

Lass uns üben!

Einführung in Generative KI in Snowflake

Preparing Video For Download...