back to integrations / Redshift (beta)
Redshift (beta)

Redshift (beta)

Fast, simple, cost-effective data warehousing.


Amazon Redshift is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools. 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. Most results come back in seconds.

Leveraging's Singer integration, you can quickly transfer data stored in Redshift for easier access and more effective collaboration on



Getting Started

Using Python 3.6+

  1. Install tap-redshift and target-datadotworld pip install tap-redshift target-datadotworld
  2. Create config-redshift.json with Redshift connection parameters (see details)
  3. Run tap-redshift in discovery mode tap-redshift -c config-redshift.json -d > catalog.json
  4. Select the tables/streams in catalog.json that you would like to sync (see details)
  5. Create config-dw.json with's connection parameters (see details)
  6. Sync your data!
    tap-redshift -c config-redshift.json --catalog catalog.json |        target-datadotworld -c config-dw.json

Ready to try it out?

Sign up for free and see how makes data work easier.

Get started!

By clicking "Continue", you are agreeing to our terms of service and privacy policy.