back to integrationsdata.world integrations / Redshift (beta)
Redshift (beta)anddata.world

Redshift (beta)

Fast, simple, cost-effective data warehousing.

Description

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 data.world's Singer integration, you can quickly transfer data stored in Redshift for easier access and more effective collaboration on data.world.


Screenshots

Makefile


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 data.world'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 data.world makes data work easier.

Get started!

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