Redshift
Connect Amazon Redshift to RevOS to enable seamless data warehousing and analytics
The RevOS Redshift Connector enables seamless integration between your Amazon Redshift data warehouse and the RevOS platform, facilitating efficient data synchronization and management. This connector supports both standard and custom Redshift schemas, allowing for flexible data operations.
Prerequisites
Before setting up the connector, ensure you have:
- An Amazon Redshift cluster with appropriate access credentials.
Important: After you create an integration, you cannot build a RevOS table directly from it. First create a semantic model based on the data that becomes available once the integration is set up; only then can you generate tables.
Setup Guide
Step 1: Prepare Your AWS Environment
Ensure Redshift Cluster Availability:
- Your Redshift cluster should be up and running with accessible network settings.
- The endpoint must include the cluster ID, region, and end with
.redshift.amazonaws.com.
Step 2: Configure the Redshift Connector in RevOS
- Enter Connection Details:
- Name: Enter a descriptive name for the connection.
- Host: Provide the Redshift cluster endpoint (must include cluster ID, region, and
.redshift.amazonaws.com). - Port: Default is
5439. - Database Name: Enter the name of the Redshift database.
- Username: Provide the username for database access.
- Password: Enter the password associated with the username.
- Configure Optional Fields:
- Schemas: Define specific schemas to be included in the synchronization process.
- JDBC URL Parameters: Additional connection properties formatted as key-value pairs separated by
&(e.g.,key1=value1&key2=value2).
Last updated on March 18, 2025