About Snowflake Notebooks¶
Snowflake Notebooks is a development interface in Snowsight that offers an interactive, cell-based programming environment for Python and SQL. In Snowflake Notebooks, you can perform exploratory data analysis, develop machine learning models, and perform other data science and data engineering tasks all in one place.
Explore and experiment with data already in Snowflake, or upload new data to Snowflake from local files, external cloud storage, or datasets from the Snowflake Marketplace.
Write SQL or Python code and quickly compare results with cell-by-cell development and execution.
Interactively visualize your data using embedded Streamlit visualizations and other libraries like Altair, Matplotlib, or seaborn.
Contextualize results and make notes about different results with Markdown cells.
Keep your data fresh by relying on the default behavior to run a cell and all modified cells preceding it or debug your notebook by running it cell-by-cell.
Run your notebook on a schedule. See Schedule your Snowflake Notebook to run.
Make use of the role-based access control and other data governance functionality available in Snowflake to allow other users with the same role to view and collaborate on the notebook.
![An example notebook in the Snowsight UI](../../_images/sf-notebooks-welcome.gif)
Get started with Snowflake Notebooks¶
To start experimenting with Snowflake Notebooks, sign into Snowsight, set up your account to use notebooks, and then select Notebooks from the Projects pane. You will find a list of notebooks that you have access to in your account. You can either create a new notebook from scratch or upload an existing ipynb file.
The following table shows the topics to review if you’re new to Snowflake Notebooks:
Getting started guides |
|
---|---|
Setting up Snowflake Notebooks Instructions for developers and admins before using Notebook. |
|
Create a new notebook from scratch or from an existing file. |
|
Develop and Run Code in Snowflake Notebook Create, edit, execute Python, SQL, Markdown cells. |
Developer guides¶
Guide |
Description |
---|---|
Accessing and modifying the session context. |
|
Saving notebooks and results across session. |
|
Importing Python package from Anaconda channel. |
|
Visualize data with matplotlib, plotly, altair and develop a data app with Streamlit. |
|
Reference SQL cell output and Python variable values. |
|
Leverage keyboard shortcut to navigate and streamline editing experience. |
Leveling up your notebook workflows¶
Guide |
Description |
---|---|
Version control your notebook for collaboration and development. |
|
Manage and work with files in your notebook environment. |
|
Schedule notebooks to run and execute code within Snowflake. |
|
Leverage other Snowflake capabilities within Snowflake Notebooks. |
|
Troubleshoot errors you may run into while using Snowflake Notebooks. |
Quickstarts¶
Getting Started with Your First Snowflake Notebook [Video] [Source]
Learn how to quickly get started with your first notebook project in less than 10 minutes.
Visual Data Stories with Snowflake Notebooks [Video] [Source]
Learn how you can create compelling data narratives using visualizations, Markdown, images, and interactive data apps all within your notebook, alongside your code and data.
Highlighted use cases¶
Check out highlighted use cases for data science, data engineering and ML/AI in Github.
Develop, manage, schedule and run scalable data pipelines with SQL and Snowpark. |
|
Explore, visualize, and analyze your data with Python and SQL. |
|
Feature Engineering, model training, and development with Cortex and Snowpark ML. |
Note
These are only shown as examples, and following along with the example may require additional rights to third-party data, products, or services that are not owned or provided by Snowflake. Snowflake does not guarantee the accuracy of these examples.
Additional resources¶
For notebook demos, tutorials and examples, see collection of Snowflake Notebooks demos in Github.
To view tutorial videos, see the Snowflake Notebooks Youtube playlist.
To learn about SQL commands to create, execute and show notebooks, see Snowflake Notebooks API reference.
Looking for reference architectures, industry specific use-cases and solutions best practices using Notebooks? See Notebooks examples in the Snowflake Solution Center.