Create Snowflake Notebooks¶

This topic describes how to create Snowflake Notebooks on a warehouse runtime. You can also create Snowflake Notebooks on container runtime for ML. For details, see Create a notebook on Container Runtime for ML.

You can access notebooks through Snowsight, where you can:

Tip

You can also create a notebook using SQL. See CREATE NOTEBOOK.

Prerequisites¶

Create a new notebook¶

You can create a new notebook by selecting + Notebook, or you can import a file with the *.ipynb extension. This could be a notebook file created from an application outside of Snowflake.

To create a new notebook, follow these steps:

  1. Sign in to Snowsight.

  2. Select Projects » Notebooks in the left-side navigation menu.

  3. Select + Notebook.

  4. To create a notebook from an existing file, such as a notebook file that was created from an application outside of Snowflake, select the down arrow and select Import .ipynb file. Open the file to import.

    Create new notebook button.

    Note

    If your notebook imports Python packages, you must add the packages to the notebook before you can run the imported notebook. See Import Python packages to use in notebooks. If the package you use in your imported notebook is not available, your code might not run. For information about adding cells, see Develop and run code in Snowflake Notebooks.

  5. Enter a name for your notebook.

    Create new notebook dialog box.

    Note

    If you’re using an AWS region, you can specify the runtime environment for your notebook: either the Container Runtime for ML or the warehouse runtime.

  6. Select a Notebook location. This is the database and schema in which to store your notebook. These cannot be changed after you create the notebook.

    Note

    The Notebook location dropdown might not show databases that were created after the Create Notebook dialog was opened. If you cannot find your recently created database, schema, or warehouse, try reloading your browser window.

    Querying data in the notebook is not restricted to this location. In the notebook, you can query data in any location you have access to. To specify the location, run USE WAREHOUSE and USE SCHEMA.

  7. (Optional) Select a Query warehouse to run any SQL and Snowpark queries issued by the notebook.

  8. Select Create to create and open your notebook.

For information about adding cells, see Develop and run code in Snowflake Notebooks.

Create a notebook from a Git repository¶

You can sync your notebook development with a Git repository. Then you can create Snowflake Notebooks from notebooks in that Git repository.

To create a notebook from a file in Git, see Create a notebook from a file in a Git repository.

Duplicate an existing notebook¶

You can duplicate existing Snowflake Notebooks. Duplicating notebooks may be useful if you want to, for example, test out some code changes without altering the original notebook version.

When you duplicate a notebook, the copied notebook is created with the same role and warehouse as the original notebook, and is contained in the same database and schema as the original notebook. Because of this, you cannot duplicate a notebook to move it to a different database and schema, or to change ownership.

To duplicate a notebook, complete the following steps:

  1. Sign in to Snowsight.

  2. Select Projects » Notebooks.

  3. Open the notebook that you want to duplicate.

  4. Select the vertical ellipsis more actions for worksheet menu, then select Duplicate.

  5. (Optional) Enter a name for the duplicate notebook, then select Duplicate.

  6. In the confirmation dialog, select Close to return to the original notebook, or Open notebook to open the duplicate notebook.

Open an existing notebook¶

To open an existing notebook, follow these steps:

  1. Sign in to Snowsight.

  2. Select Notebooks.

    Note

    Recently used notebooks also appear in Snowsight. Under Recently viewed, select Notebooks.

  3. Review the list of notebooks.

    You can see all notebooks owned by your active role or owned by a role inherited by your active role.

  4. Select a notebook to open it for editing.

    For details about editing notebooks, see Develop and run code in Snowflake Notebooks.

When you open a notebook, you can see cached results from the last time you ran any cells in the notebook. The notebook is in the Not connected state by default, but if you select that state or run any cell, your notebook connects to your virtual warehouse.

Language: English