~/talk

Machine Learning in the Warehouse with Python

Talkat PyData Global 2022 · 2022-12-01..12-03· [databases, python]
slides:none on file

Demonstrates that Snowpark for Python lets notebooks prototype, train, save and run models without exporting data: code registers a local function and a conda-style environment, the model binary lands in a Snowflake stage, predictions run over table rows via SQL-backed Python user-defined functions, and results get written back to a new table. Demo uses pandas and scikit-learn inside Deepnote, and notes limits on training millions of rows without provisioning larger Snowflake resources.

AI-written summary · about

  1. 0:00Introduction
  2. 1:11Snowpark and Deepnote integration
  3. 3:59SQL without writing SQL
  4. 7:57Demo setup
  5. 10:28Exploratory data analysis
  6. 15:03Prototyping locally
  7. 16:50Deploying models
  8. 18:16UDFs for predictions
  9. 21:30Snowpark ML workflow
  10. 23:16Deepnote EDA resources
  11. 24:17Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.