Setting general connection parameters
This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.
To add a Snowflake on Google target endpoint to Qlik Replicate:
- In the Qlik Replicate Console, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box.
- In the Manage Endpoint Connections dialog box, click New Endpoint Connection.
- In the Name field, enter a display name for your Snowflake on Google endpoint.
- Optionally, in the Description field, enter a description for your Snowflake on Google target endpoint.
-
Select Target as the role.
-
Select Snowflake on Google as the Type.
-
Configure the remaining settings in the General tab as described in the tables below.
Snowflake Access configuration Option Description Snowflake Account/Host
Your URL for accessing Snowflake on Google. User name
Your Snowflake user name. Password
The password for the user entered in the User name field. Warehouse
The name of your Snowflake warehouse.
Database name
The name of your Snowflake database.
Staging on Google Cloud Storage configuration Option Description JSON credentials
The JSON credentials for the service account key with read and write access to the Google Cloud Storage bucket.
Bucket name
The Google Cloud Storage bucket.
Staging folder
Where to create the data files in the specified bucket.
Storage integration name
Your storage integration name. Integrations avoid the need for passing explicit cloud provider credentials such as secret keys or access tokens; instead, integration objects reference a Cloud Storage service account.
For more information on creating a storage integration name, see https://docs.snowflake.com/en/user-guide/data-load-gcs-config.html
To determine if you are connected to the database you want to use or if the connection information you entered is correct, click Test Connection.
If the connection is successful a message in green is displayed. If the connection fails, an error message is displayed at the bottom of the dialog box.
To view the log entry if the connection fails, click View Log. The server log is displayed with the information for the connection failure. Note that this button is not available unless the test connection fails.