Skip to main content
Setting general connection parameters

ON THIS PAGE

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 AWS target endpoint to Qlik Replicate:

  1. In the Qlik Replicate Console, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box.
  2. In the Manage Endpoint Connections dialog box, click New Endpoint Connection.
  3. In the Name field, specify a name for your Snowflake on AWS endpoint.
  4. Optionally, in the Description field, enter a description for the Snowflake on AWS target endpoint.
  5. Select Target as the role.

  6. Select Snowflake on AWS as the Type.

  7. Configure the remaining settings in the General tab as described in the table below.

    • Snowflake on AWS Target:
      • Snowflake URL: Your URL for accessing Snowflake on AWS.
      • 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 - Choose either Snowflake or AWS S3.
      If you selected AWS S3, provide the following information:
      • Bucket name: The name of the Amazon S3 bucket to where the files will be copied.
      • Bucket region: The Amazon S3 region where the S3 buckets and folders you are using are hosted. The default value is US East (N. Virginia).
      • Access type: Choose one of the following:
        • Key pair - Choose this method to authenticate with your Access Key and Secret Key. Then provide the following additional information:
          • Access key: Type the access key information for Amazon S3.
          • Secret key: Type the secret key information for Amazon S3.
        • IAM Roles for EC2 - Choose this method if the machine on which Qlik Replicate is installed is configured to authenticate itself using an IAM role. Then provide the following additional information:
          • External stage name: The name of your external stage. To use the IAM Roles for EC2 access type, you must create an external stage that references the S3 bucket.

          To use the IAM Roles for EC2 access method, you also need to fulfill the prerequisites described in Prerequisite for using the IAM Roles for EC2 Access Type.

      • Folder: The bucket folder to where the files will be copied.
Information noteThe information for these properties is available from the account page for Amazon Web Services (AWS) with the Snowflake on AWS cluster. If you do not have these values, refer to your AWS account or the Snowflake on AWS System Administrator for your enterprise.

Prerequisite for using the IAM Roles for EC2 Access Type

To use the IAM Roles for EC2 access type, you must run the following commands on the Snowflake on AWS database before running the task:

Command 1:

create or replace file format MY_FILE_FORMAT TYPE='CSV' field_delimiter=','compression='GZIP' record_delimiter='\n' null_if=('attrep_null') skip_header=0 FIELD_OPTIONALLY_ENCLOSED_BY='\"';

Command 2:

create or replace stage “PUBLIC”.MY_S3_STAGE file_format=MY_FILE_FORMAT url='s3://MY_STORAGE_URL' credentials=(aws_role='MY_IAM_ROLE');

Where:

MY_FILE_FORMAT - Can be any value.

MY_S3_STAGE - The name specified in the External stage name field above.

MY_STORAGE_URL - The URL of your Amazon S3 bucket

MY_IAM_ROLE - Your IAM role name.

Information note

 

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.