Redshift Setup Guide

Prerequisites

This page guides you through the process of setting up the Redshift destination connector.

You'll have to do the following:

• Provide the following fields: Username, Password, Hostname, Port, Database.
• Allow Matia IP addresses to access your Redshift.

Get Endpoint(Hostname), Port, and Database.

1. Navigate to Redshift's console

2. In the left menu, click Clusters

3. Select the cluster you want Matia to connect to.

4. Locate the Endpoint field in the General Information pane. Copy it (It includes the port and database as well). Separate the Endpoint into 3 components(Hostname, Port, and Database).

   • The format is: hostname:port/database
   • Be sure to separate the port and remove the preceding colon (:) from the host string.

5. Then, fill the fields in forms with the corresponding component.

Create User and Grant Required Permissions

1. To create a dedicated user, run the following query:

   CREATE USER <matia_user_name> PASSWORD <your_password_here>;

   For more information about creating a user in Redshift, check the redshift documentation.

2. Execute the following query to grant the user the following privileges:

   • CREATE: Allows the user to create new schemas in the database
   • TEMPORARY: Allows the user to create temporary tables while using the database

   GRANT CREATE, TEMPORARY ON DATABASE <database> TO <matia_user_name>;

   For more information about granting permissions to a user in Redshift, check the redshift documentation.

3. Fill in the username and password fields in the forms.

Allow Matia to connect

1. In the Redshift console, click Clusters.

2. Select the cluster you want Matia to connect to.

3. Click Properties.

4. Scroll down to the "Network and security settings section".

5. In the VPC security group field, click the security group to open it.

6. In the Security Groups window, click Inbound rules.

7. In the Edit Inbound rules window, follow the steps below to create custom TCP rules for each of Matia's IPs in your region:

• Select Custom TCP in the drop-down menu.
• Enter your Redshift port number.
• Enter Matia IP addresses from the following list:
  • 52.20.96.22/32
  • 23.21.86.124/32
  • 44.219.180.239/32

Setup Guide

1. Fill in the Username, Password, Hostname, Port and Database for your Redshift database.
2. Enter a Name for the connector.
3. (Optional) Enter a Description for the connector.
4. Select the Owner of the connector.
5. (Optional) Verify that your Redshift database is successfully connected by clicking on Test Connection.
6. Click Connect.