Snowflake + Posit
Streamline MLOps with Snowflake and Posit
See an end-to-end demo of deploying Scikit-learn models using Lending Club data to optimize your production workflow.
Table of contents
Intro to Orbital
For converting models to SQL to run predictions inside databases
Running Positron within Snowflake
Positron in Posit Workbench as a native app within Snowflake
Connect to the data
Loan dataset from LendingClub.
Feature engineering and model fitting pipeline with scikit-learn
Save model to Snowflake model registry
Parsing the sci-kit learn pipeline with Orbital to convert to SQL
Model predictions for 2.25 million rows in Snowflake in less than 5 seconds
Create a Snowflake view (saved SQL query)
What Orbital can & can't do
Additional Resources
Follow along with us
Blog post: In-database scoring with Snowflake
Install Orbital package for Python
Install Orbital package for R