Amazon Redshift Source Adaptor

Updated Jun 09, 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. 

Redshift Source Adaptor

The K3 Amazon Redshift Source Adaptor supports pulling data from an Amazon Redshift database. The following instructions will walk you through how to setup the Redshift 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 User Enter a user that has permissions to ready from the Redshift database which you will be connecting to.
DB Password Enter a password for the user provided in the DB User field.
DB Subname
Enter the Database Server and database useing the following format:

//<ServerName>:<Port>/<DB Name>

2. Click the Build Query Button

Clicking Build Query starts the process of building the SQL query to pull data from the Redshift database previously configured.

 

3. Select the table to query

The build query screen allows you to select a table to query without writing any SQL. Select the table to query from the tables in the drop down list.

4. Select the column K3 should use to track whether there are new records in the table.

Selecting the column K3 will use the selected column to determine if there are new records in the table. This is done by keeping track of the latest value, for the selected column, which K3 has processed and then using that value determine if there is newer value. Most often unique ids or time stamps are the best columns to use.

5. Review the query and adjust the poll schedule

Once you complete the query process and click save the query will display along with the column used to poll. Finally, the poll schedule needs to be determined. K3 currently supports Cron scheduling, which is the default, and periodic schedule.  

 

Configuration Field Value
Schedule Cron (only available if you select Cron Scheduling) Enter the Cron schedule script to determine when the poll will run.
Poll Delay  (only available if you select Periodic Scheduling) Enter the Poll Delay in milliseconds to determine when the poll will run.
Previous Article How do I sign-in to K3?
Next Article Amazon Redshift Target Adaptor