Data sources
AWS Redshift
Amazon Redshift is a fast, fully managed cloud data warehouse that makes it simple and cost-effective to analyze all your data. It allows you to run complex analytic queries against petabytes of structured data, using sophisticated query optimization, columnar storage on high-performance local disks, and massively parallel query execution.
The integration between AWS Redshift and Togai requires only a one-time setup. Follow the steps below:
Prerequisites
Create a read-only user
- Create a read-only user in AWS Redshift
- Grant the user access to the tables that you want to sync with Togai
- Make sure that the user has access to the tables that you want to sync with Togai
Install
- Navigate to the Integrations section from the left navigation bar in Togai
- Click on
Apps
to access the list of apps with integration support - Select
AWS Redshift
from the available apps - Click on the
+Add connection
button - Provide a name for the connection and paste your:
Connection URI
: The connection URI for your AWS Redshift database
Connection URI
The syntax for the AWS Redshift connection URI using the username and password authentication:
jdbc:redshift://redshift.company.us-west-1.redshift.amazonaws.com:9000/dev;UID=amazon;PWD=amazon
You can construct the connection URI using the AWS Redshift documentation
Flows
Sync customer from AWS Redshift to Togai
- The flow will be available to be triggered on demand from the Togai dashboard
- It will execute a SQL query to fetch all the customers from AWS Redshift
- It will then create the customers in Togai using the
Customers
API
Sync events from AWS Redshift to Togai
- The flow will be available to be triggered on demand from the Togai dashboard
- It will execute a SQL query to fetch all the events from AWS Redshift
- It will then create the events in Togai using the
Event Ingestion
API