Amazon Redshift

Overview

Use this connector to extract metadata from Amazon Redshift clusters.

Create User & Grant Permissions

Run the following SQL commands to create a dedicated user and grant the required read-only permissions:

• CREATE USER connetra PASSWORD '<password>';
• ALTER USER connetra SYSLOG ACCESS UNRESTRICTED;
• GRANT REFERENCES ON ALL TABLES IN SCHEMA <schema_name> TO connetra;
• GRANT SELECT ON ALL TABLES IN SCHEMA <schema_name> TO connetra;
• GRANT SELECT ON svv_table_info TO connetra;

Connection Setup in Connetra

When adding a data connector in Connetra, provide the following details:

• Configuration name: A user-friendly label for this connection. It helps team members identify and select the connector within Connetra
• Host/server: The network address or domain name of the database server where your data is stored.
• Port: The communication port used to connect to the database
• User: The database account Connetra will use to connect and retrieve metadata. This user should have read-only permissions.
• Password: The password associated with the user account above, used to authenticate the connection.
• Database name: The name of the database where your data is stored.

Before you can save the data connector you must first test the connection.