Snowflake

Deepnote does not yet have a dedicated Snowflake integration. However, if you set up your Snowflake environment variables and the Snowflake Python connector, you can get up and going in a couple of minutes.

All you need to do is follow the Snowflake Python connector installation guide and set the correct environment variables (such as USER_NAME, PASSWORD, ACCOUNT_NAME ). Below is a step-by-step guide of the process.

Step 1

Install the required system libraries.

!sudo apt-get update
!sudo apt-get install -y libssl-dev libffi-dev

Step 2

Install the Python connector library through pip.

!pip install --upgrade snowflake-connector-python

Step 3

Create a new environment variable integration and replace the <values> in the Snowflake Python connector.

#!/usr/bin/env python
import snowflake.connector
​
# Gets the version
ctx = snowflake.connector.connect(
    user='<your_user_name>',
    password='<your_password>',
    account='<your_account_name>'
    )
cs = ctx.cursor()
try:
    cs.execute("SELECT current_version()")
    one_row = cs.fetchone()
    print(one_row[0])
finally:
    cs.close()
ctx.close()

Step 4

Your notebook is now connected to your Snowflake instance. Follow the usage instructions from the official documentation.