Redshift Integration
What is Amazon Redshift?
Amazon Redshift is a cloud-based data warehousing service that enables businesses to store, analyze, and process large-scale datasets efficiently. It offers fast query performance, scalability, and seamless integration with other AWS services, making it a popular choice for business intelligence and analytics.
How to use Parabola's Redshift integration
Parabola's Redshift integration helps businesses automate data workflows and enhance analytics capabilities.
- Import and export structured data between Redshift and other platforms
- Transform and optimize Redshift data for deeper analysis and reporting
- Sync Redshift data with other business tools for seamless automation and insights
Learn more about Parabola’s Redshift integration below.
Pull from Redshift
The Pull from Redshift step connects to and pulls data that is stored in your Amazon Redshift database. Amazon Redshift is a data warehouse product within the AWS ecosystem.
Connect your Amazon Redshift database
Double-click on the Pull from Redshift step and click Authorize. These are the following fields required to connect:
- Hostname
- Username
- Password
- Database
- Port (Optional)
If no port is specified during authorization, this step will default to post 5439.
You can leave fields blank (like Password) if they are not needed for the database to authorize connection.
Custom settings
Once you are successfully connected to your database, you'll first see a dropdown option to select a table from your Redshift database. By default, Parabola pulls the whole table using the query:
select *
If you'd like to be able to pull in more specific, relevant data, or reduce the size of your default import, you can do so by writing your own SQL statement to filter your table's data.
To do so, click into "Advanced Settings" and input your query into the Query (optional) field.