Amazon Redshift
Connecting DinMo to Redshift: Step-by-Step Guide
Go to the workspace settings, then to the Source tab, and click "Add New Source".
Step 1: Select Amazon Redshift from the list of available sources
Step 2: Create a DinMo user on Amazon Redshift and the DinMo technical datasets. DinMo needs to read all the tables that you want to use to build models and segments. It also needs to write access to 3 schemas that will be used to store technical (segment queries, segment stats, activation snapshots).
We recommend you to create a specific user for DinMo and grant it the needed permissions.
You can do so by running the following SQL snippet.
Please edit the <value>
fields in the script to define your own credentials and parameters.
Step 3: Fill in the required information
Host: The hostname or IP address of your Redshift cluster. It can be found by visiting the Redshift web console, navigating to the Clusters panel, and clicking your cluster. Copy the Endpoint string, excluding the port and database name.
Database: The name of the database in your Redshift cluster. Most clusters have only one database. Visit the Redshift web console, navigate to the Clusters panel, and click your cluster. The database name is shown in the Properties tab.
Port: The port number of your Redshift cluster. The default is 5439, but yours may be different. To confirm, visit the Redshift web console, navigate to the Clusters panel, and click your cluster. The port number is shown in the Properties tab.
User and password: The credentials you created in the script above.
Step 4: Hit "Save & Test". This will launch a test ensuring that the connection is working. If so, congratulations, your source setup is finished!
Last updated