Snowflake
Snowflake is a large-scale cloud-based data warehouse. This article will cover how to connect to Snowflake from Noteable.

Connect to Snowflake.ipynb | Noteable
Demo notebook
You will need the following information to create the connection:
- Username
- Password or Access Token
You may optionally provide:
- Warehouse
- Database
- Schema
- Role
If your data source is behind a firewall, you will need to ensure your firewall accepts incoming connections from Noteable. Read more: Data Connections
To create a data connection:
- 1.Pick connection type.
- 2.Store credentials.
- 3.Start or restart the kernel.
There are multiple places you can create data connections:
Notebook
Resources page
To add a data connection from the notebook:
- 1.Open the Data Connections panel by clicking on the database icon () in the left sidebar.
- 2.Click on thesign to launch the Create a data connection modal.
- 3.Select Snowflake for the connection type.
- 4.Provide a Name for the data connection and a description, if desired.
- 5.Provide your Account Identifier.
- 6.Provide your Username.
- 7.Provide your Access Token.
- 8.Provide the Database name (default: default).
- 9.Provide the Warehouse, Database, Schema, or Role, if desired.
- 10.
- Private connections can only be seen, managed, or accessed by the user who created the connections, and can be used in any space.
- Space-level connections can be seen and managed by all users who have Contributor or Owner access for the space but can only be used in notebooks within the designated space.
- 11.Click Create.
- 12.Restart the kernel, if prompted.
To add a data connection from the resources page:
- 1.Click on the Data Connections link in the main sidebar. This sidebar is visible from all space or project pages.
- 2.Click on the +Create a data connection button to launch the Add data connection modal.
- 3.Select Databricks for the connection type.
- 4.Select Snowflake for the connection type.
- 5.Provide a Name for the data connection and a description, if desired.
- 6.Provide your Account Identifier.
- 7.Provide your Username.
- 8.Provide your Access Token.
- 9.Provide the Database name (default: default).
- 10.Provide the Warehouse, Database, Schema, or Role, if desired.
- 11.
- Private connections can only be seen, managed, or accessed by the user who created the connections, and can be used in any space.
- Space-level connections can be seen and managed by all users who have Contributor or Owner access for the space but can only be used in notebooks within the designated space.
- 12.Click Create.
- 13.Restart any running kernels to use this connection.
Last modified 3mo ago