Snowflake

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 xx12345.us-central1.gcp)

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