Snowflake Notebook Demos

Snowflake Notebooks is your familiar, interactive development environment to perform Data Science, Data Engineering, and AI/ML workloads end-to-end in Snowflake. Write Python & SQL in the same interface.

This repo contains a collection of Snowflake Notebook demos, tutorials, and examples. Browse each folder to access the notebook files associated with each demo. Here is a list of notebooks you can find in this repo.
<table>
<tr>
<td style="vertical-align: top;">
<img src="https://docs.snowflake.com/_images/create-sf-notebooks-tile.png" alt="Image" style="width:100px">
</td>
<td style="vertical-align: center;">
<h4>Getting Started</h4>
<ul>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/My%20First%20Notebook%20Project/My%20First%20Notebook%20Project.ipynb">My First Notebook Project</a> <a href="https://www.youtube.com/watch?v=tpg35YgA9Gk">🎥</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Visual%20Data%20Stories%20with%20Snowflake%20Notebooks/Visual%20Data%20Stories%20with%20Snowflake%20Notebooks.ipynb">Visual Data Stories With Snowflake Notebooks</a> <a href="https://www.youtube.com/watch?v=WJUNTudCsYM">🎥</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Reference%20cells%20and%20variables/Reference%20cells%20and%20variables.ipynb">Reference cells and variables</a></li>
</ul>
</td>
</tr>

<tr>
<td style="vertical-align: top;">
<img src="https://docs.snowflake.com/_images/data-science-notebooks-tile.png" alt="Image" style="width:100px">
</td>
<td style="vertical-align: top;">
<h4>Data Administration</h4>
<ul>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/MFA_Audit_of_Users/MFA_Audit_of_Users_with_Streamlit_in_Snowflake_Notebooks.ipynb">Multi-Factor Authentication Audit of Users with Streamlit in Snowflake Notebooks</a> <a href="https://youtu.be/WojbkHRCiHU">🎥</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Query_Performance_Insights/Automated_Query_Performance_Insights_in_Snowflake_Notebooks.ipynb">Automated Query Performance Insights in Snowflake Notebooks</a> <a href="https://youtu.be/h_pb4qdTfzg">🎥</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Query_Performance_Insights_using_Streamlit/Build_an_Interactive_Query_Performance_App_with_Streamlit.ipynb">Interactive Query Performance App in Snowflake Notebooks using Streamlit</a> <a href="https://youtu.be/vdW8xZYBOI0">🎥</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Monitoring_Table_Size_with_Streamlit/Monitoring_Table_Size_with_Streamlit.ipynb">Monitoring the Table Size in Snowflake Notebooks with Streamlit</a> <a href="https://youtu.be/ANlzffewNGk">🎥</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Role_Based_Access_Auditing_with_Streamlit/Role_Based_Access_Auditing_with_Streamlit.ipynb">Role-Based Access Auditing in Snowflake Notebooks with Streamlit</a>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Warehouse_Utilization_with_Streamlit/Warehouse_Utilization_with_Streamlit.ipynb">Warehouse Utilization in Snowflake Notebooks with Streamlit</a> <a href="https://youtu.be/fpVAe0BHc7Q">🎥</a></li>
</ul>
</td>
</tr>

<tr>
<td style="vertical-align: top;">
<img src="https://docs.snowflake.com/_images/create-sf-notebooks-tile.png" alt="Image" style="width:100px">
</td>
<td style="vertical-align: top;">
<h4>Data Engineering</h4>
<ul>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Create%20and%20Manage%20Snowflake%20Objects%20like%20a%20Pro/Create%20and%20Manage%20Snowflake%20Objects%20like%20a%20Pro.ipynb">Create and Manage Snowflake Objects Like a Pro</a> <a href="https://www.youtube.com/watch?v=Dj8aAoEOfrw">🎥</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Data%20Engineering%20Pipelines%20with%20Snowpark%20Python/Data%20Engineering%20Pipelines%20with%20Snowpark%20Python.ipynb">Data Engineering Pipelines with Snowpark Python</a> <a href="https://www.youtube.com/watch?v=mpstEt0fU8U">🎥</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Creating%20Snowflake%20Object%20using%20Python%20API/Creating%20Snowflake%20Object%20using%20Python%20API.ipynb">Creating Snowflake Object using Python API</a></li>
</ul>
</td>
</tr>
<tr>
<td style="vertical-align: top;">
<img src="https://docs.snowflake.com/_images/ml-notebooks-tile.png" alt="Image" style="width:100px">
</td>
<td style="vertical-align: top;">
<h4>Machine Learning</h4>
<ul>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/tree/main/End-to-End%20Machine%20Learning%20with%20Snowpark%20ML">End-to-End Machine Learning with Snowpark ML</a> <a href="https://www.youtube.com/watch?v=LeSGBW0YoLg">🎥</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Hyperparameter%20Tuning%20with%20sklearn/Hyperparameter%20Tuning%20with%20sklearn.ipynb">Hyperparameter Tuning with sklearn</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Getting%20Started%20with%20Snowflake%20Cortex%20ML-Based%20Functions/Getting%20Started%20with%20Snowflake%20Cortex%20ML-Based%20Functions.ipynb">Getting Started with Snowflake Cortex ML-Based Functions</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Feature%20Store%20API%20Overview/Feature%20Store%20API%20Overview.ipynb">Feature Store API Overview</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/End-to-end%20ML%20with%20Feature%20Store%20and%20Model%20Registry/End-to-end%20ML%20with%20Feature%20Store%20and%20Model%20Registry.ipynb">End-to-end ML with Feature Store and Model Registry</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Manage%20features%20in%20DBT%20with%20Feature%20Store/Manage%20features%20in%20DBT%20with%20Feature%20Store.ipynb">Manage features in DBT with Feature Store</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/ML%20Lineage%20Workflows/ML%20Lineage%20Workflows.ipynb">ML Lineage Workflows</a></li>
</ul>
</td>
</tr>
<tr>
<td style="vertical-align: top;">
<img src="https://docs.snowflake.com/_images/develop-sf-notebooks-tile.png" alt="Image" style="width:100px">
</td>
<td style="vertical-align: top;">
<h4>Using Notebooks</h4>
<ul>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Import%20Package%20from%20Stage/Import%20Package%20from%20Stage.ipynb">Import Custom Package from Stage into Notebook</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Working%20with%20Files/Working%20with%20Files.ipynb">How to work with Files in Snowflake Notebooks</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Navigating%20and%20Browsing%20Files/Navigating%20and%20Browsing%20Files.ipynb">Navigating and Browsing Files in Snowflake Notebooks</a></li>
<li><a href="https://github.com/Snowflake-Labs/snowflake-demo-notebooks/blob/main/Access%20External%20Endpoints/Access%20External%20Endpoints.ipynb">Access External Endpoints</a></li>
</ul>
</td>
</tr>
</table>

Load demo notebooks to Snowflake

The notebook files are available for download as .ipynb files. To load the demo notebooks into your Snowflake Notebook, follow these steps:

On Github, click into each folder containing the tutorial and the corresponding .ipynb file, such as this. Download the file by clicking on the Download raw file from the top right.
Go to the Snowflake web interface, Snowsight, on your browser.
Navigate to Project > Notebooks from the left menu bar.
Import the .ipynb file you've download into your Snowflake Notebook by using the Import from .ipynb button located on the top right of the Notebooks page.
Select the file from your local directory and press Open.
A Create Notebook dialog will show up. Select a database, schema, and warehouse for the Notebook and click Create.

Resources

Here are some resources to learn more about Snowflake Notebooks:

License

All code and notebooks included in this repo is available with an Apache 2.0 license.

snowflake-demo-notebooks

README

Snowflake Notebook Demos

Load demo notebooks to Snowflake

Resources

License

Other links