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.
|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.
||Enter the Database Server and database useing the following format:
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.
|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.|