Snowflake Target Adaptor

Updated Jun 08, 2020

Amazon Redshift is an Internet hosting service and data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services.

Below you will find details on how to configure the K3 Redshift Adaptor to connect an Amazon Redshift instance. 

Snowflake Target Adaptor

The K3 Snowflake Target Adaptor supports pushing data to a Snowflake database. The following instructions will walk you through how to set up the Snowflake Target adaptor.

1. Enter the connection information and click the Test button

Assuming the connection information is correct a success message will be shown. If you have successfully tested the connection click the OK button.  

Configuration Parameter Description
DB Subname
Enter the Database Server and database useing the following format:

//<Snowflake Server>/?db=<DB Name>

Please note the database name is passed in the parameter “db”.
DB User
Enter a user that has permissions to ready from the Snowflake database which you will be connecting to.
DB Password
Enter a password for the user provided in the DB User field.

2. Click the Build Query Button

Clicking Build Statement starts the process of building the SQL Insert Statement to push data into the Snowflake database previously configured.

 

3. Select the table to insert into

The Statement Builder screen allows you to select a table to insert into without manually writing any SQL. Select the table to insert into, from the list of tables in the drop-down list.

4. Select the columns K3 should insert data into

Selecting the columns will build an insert query using those columns and create the target field list in K3. You are able to see the query and modify that query by clicking "Customize Query". Using "Customize Query" is only recommended for advanced users. Once you have selected the desired columns, click OK.

5. Review the Insert

Once you complete the field selection process and click save the Insert statement will be displayed. At this point, the adaptor is configured. Please be aware that you must configure the source adaptor and name the route before moving on.  

 

If you ever need to adjust the Insert statement you can click Edit Statement. This will bring you back into the column selection process.

 

Note: The columns identified in the Column selection will be available to add to the Target Field list when you initially attempt to add fields. 

Previous Article Amazon Redshift Target Adaptor
Next Article CSV Upload Adaptor