Sign inGet started

Getting started

Welcome to Deepnote

Connecting to data sources

Snowflake

Coding and analysis tools

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).

sf.png

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')