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
- Note that while Parabola can pull data from Redshift, we do not currently support writing data to Redshift today.
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 (optional)
- Database
- Port (optional; defaults to 5439)
You can leave fields blank (like Password) if they are not needed for the database to authorize connection.
Choose what to import
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 pull in more specific data—or reduce the size of your import—you can write your own SQL statement. To do this, simply enter your query into the ‘Query (optional)’ field.
Get help from AI
When working in the ‘Query (optional)’ field, you’ll see two buttons that connect directly to AI chat:
- “Help write query”: Use this when you want AI to draft a query for you. Describe the data you want in plain language (for example, “Show me the last 30 days of shipped orders”), and AI will write the SQL.
- “Optimize query”: Use this after you’ve written a query. AI can help fix errors, improve performance, or enhance the query based on your instructions. This is especially useful if you run into SQL syntax errors.
Both buttons open the AI chat interface, where you can refine the query until it’s ready to use.