Redshift
Instructions for connecting to a Redshift data warehouse as a source
Step 1: Find endpoint details
- In the Redshift console, click Clusters.
- Select the cluster you would like to connect.
- In the General information pane, make note of the Endpoint details. You made need to use the copy icon to copy the full details to discover the full endpoint and port number.
Step 2: Allow Prequel to connect
- In the Redshift console, click Clusters.
- Select the cluster you would like to connect.
- Click the Properties tab.
- Scroll down to the Network and security settings section.
- In the VPC security group field, select a security group to open it.
- In the Security Groups window, click Inbound rules.
- Click Edit inbound rules.
- In the Edit the Inbound rules window, follow the steps below to create custom TCP rules for Prequel's IP:
a. Select Custom TCP in the drop-down menu.
b. Enter your Redshift port number. (likely5439
)
c. Enter the Prequel static IP address.
d. Click Add rule.
Step 3: Create a Limited User
- Connect to Redshift using the SQL client.
- Execute the following query to create a user (replace
<password>
with a password of your choice).
CREATE USER <username> PASSWORD '<password>';
- Execute the following query to grant the prequel user read-only privileges (replace
<database>
with your database name):
GRANT USAGE ON SCHEMA <schema> TO <username>;
GRANT SELECT ON ALL TABLES IN SCHEMA <schema> TO <username>;
Step 4: Add source to Prequel
Use the UI or a cURL request to add the configured source to Prequel.
- The name is a descriptive name of the source for your purposes (i.e., a description)
- The host [for example,
source-redshift.cw1drqwgbdue.us-east-1.redshift.amazonaws.com
] - The port [most likely
5439
] - The vendor:
redshift
- The database from which tables will be read
- The username from Step 3
- The password from Step 3
Updated 4 months ago