Adding Snowflake support (Data Virtualization)

You must configure the Snowflake as a data source before you can use it in Data Virtualization.

1. Click Data > Data Virtualization > Data sources.
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.

4. Click Create to add the connection to the data source environment.

Results

You can now use your Snowflake database as a data source in Data Virtualization.