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