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

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

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. From the drop down menu, select the table that you want to insert data into.

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 it 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.