Snowflake is a cloud-based data-warehouse. This topic describes how to connect to Snowflake from Domino.
You must have network connectivity between Snowflake and your Domino deployment.
To use Snowflake code integrations, such as Snowpark, you must agree to the Snowflake third party terms. To agree to these terms, you must have a Snowflake account with the ORGADMIN role. If you don’t have access to a Snowflake account with the ORGADMIN role, submit a Snowflake support ticket.
Domino recommends that you use a Domino data source to connect to a Snowflake instance from Domino.
-
From the navigation pane, click Data.
-
Click Create a Data Source.
-
In the New Data Source window, from Select Data Store, select Snowflake.
- Account Name
-
If the Domino deployment and Snowflake data source, are in the same region, enter the Account Name as
<account name>. However, if the Domino deployment and Snowflake data source are in different regions, enter the Account Name as<account name>.<region>. For example,abc.us-east. - Optional: Database
-
The name of the Snowflake database that contains the data.
- Optional: Schema
-
The name of the active schema for the session.
- Optional: Warehouse
-
The name of all the compute resource clusters that provide the resources in Snowflake.
- Optional: Role
-
The role that has privileges to the data source.
- Data Source Name
-
The name that identifies the data source.
- Optional: Description
-
The purpose for the data source.
-
Click Next.
-
Enter the Username and Password to connect to Snowflake. Only basic (username/password) authentication is supported. The Domino secret store backed by HashiCorp Vault securely stores the credentials.
-
Click Test Credentials.
-
If the data source authenticates, click Next (or Skip for Now to configure authentication later).
-
Select who can view and use the data source in projects.
-
Click Finish Setup.
If your users have Domino permissions to use the data source and enter their credentials, they can now use the Domino Data API to retrieve data with the connector.
See Retrieve data for more information.
-
Use the Snowflake Python connector (snowflake-connector-python).
-
Use the following Dockerfile instruction to install snowflake-connector-python and its dependencies in your environment.
USER root
RUN apt-get install -y libssl-dev libffi-dev && \
pip install -U pip && pip install --upgrade snowflake-connector-python
USER ubuntu+ If you encounter an error due to your Ubuntu version, use the following Dockerfile instruction:
+
USER root
RUN pip install -U pip && pip install --upgrade snowflake-connector-python
USER ubuntu-
Set the following Domino environment variables to store secure information about your Snowflake connection.
-
SNOWFLAKE_USER -
SNOWFLAKE_PASSWORD -
SNOWFLAKE_ACCOUNTSee Environment variables for secure credential storage to learn more about Domino environment variables.
-
-
See Snowflake python connector for information about how to use the package. The following is an example.
import snowflake.connector import os # Gets the version ctx = snowflake.connector.connect( user=os.environ['SNOWFLAKE_USER'], password=os.environ['SNOWFLAKE_PASSWORD'], account=os.environ['SNOWFLAKE_ACCOUNT'] cs = ctx.cursor() try: cs.execute("SELECT current_version()") one_row = cs.fetchone() print(one_row[0]) finally: cs.close() ctx.close()You can also use generic Python JDBC or ODBC tools to connect to Snowflake. However, they are not specialized for use with Snowflake. They can have inferior performance and will require more time to set up.
For more information about JDBC and ODBC connections, see: