Connecting to Snowflake in Data Virtualization
You must configure Snowflake as a data source before you can create a connection to it in Data Virtualization.
Procedure
To connect to Snowflake in Data Virtualization, follow these steps.
On the navigation menu, click Data sources page by default.
. The service menu opens to the-
Select the Snowflake data source connection.
-
Specify the following information:
- The full name of your Snowflake account.
- The name of the database
- Specify the schema information in the Additional properties field by
using the following
format:
schema=Schema_Name
- Any additional properties required to create the connection.
- The default access control role to use in the Snowflake session.
- The virtual warehouse.
- The username and password that allow access to the
data source.Note: The username and password that is specified here refer to an ID with read-only access to the data source. This user is required for accessing data from the data source and does not necessarily correspond to a Cloud Pak for Data username or a Data Virtualization user ID.
For some data sources, you can use the Cloud Pak for Data credentials to access the data source. To do so, select the corresponding checkbox.
- The Okta URL endpoint. If your company uses native
Okta SSO authentication, enter the Okta URL endpoint for
your Okta account. For example,
https://<okta_account_name>.okta.com
. Leave this field blank if you want to use default authentication.
-
Click Create to add the connection to the data source environment.
You can also configure Snowflake to use an Okta
authenticator by using the setRdbcX stored procedure. The
Snowflake
Okta authentication URL can be passed in using the
connection_options parameter. For example, you can specify
authenticator=https://<okta_account_name>.okta.com
.
Results
You can now use your Snowflake database as a data source in Data Virtualization.