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.