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.

  1. On the navigation menu, click Data > Data virtualization. The service menu opens to the Data sources page by default.

  2. Select the Snowflake data source connection.

  3. Specify the following information:

    1. The full name of your Snowflake account.
    2. The name of the database
    3. Specify the schema information in the Additional properties field by using the following format:
      schema=Schema_Name
    4. Any additional properties required to create the connection.
    5. The default access control role to use in the Snowflake session.
    6. The virtual warehouse.
    7. 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.

    8. 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.
  4. 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.