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
ACCOUNT_NAME ). Below is a step-by-step guide of the process.
Install the required system libraries.
!sudo apt-get update!sudo apt-get install -y libssl-dev libffi-dev
Install the Python connector library through pip.
!pip install --upgrade snowflake-connector-python
Create a new environment variable integration and replace the
<values> in the Snowflake Python connector.
#!/usr/bin/env pythonimport snowflake.connector# Gets the versionctx = 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)finally:cs.close()ctx.close()
Your notebook is now connected to your Snowflake instance. Follow the usage instructions from the official documentation.