Getting started
Working with files
Connecting to data sources
Coding and analysis tools
Collaboration
Security and privacy
Deepnote for education
Additional resources
Snowflake
Available on Team and Enterprise plans
Deepnote connects to Snowflake through the Python connector. In order to create the connection, you will need to fill out your username, password and the account_name (the account name should be entered in the format (accountname.snowflakecomputing.com
).
Once your project is connected to your Snowflake instance, you can use SQL cells to query your Snowflake database.
Alternatively, you can follow the usage instructions from the official documentation. You'll be able to connect to and query your cluster like this:
import snowflake.connector
conn = snowflake.connector.connect(
user='USER',
password='PASSWORD',
account='ACCOUNT',
warehouse='WAREHOUSE',
database='DATABASE',
schema='SCHEMA'
)
conn.cursor().execute('select * from products')