Amazon Redshift (beta)
Connect Amazon Redshift to Inconvo.
Redshift support is in beta. Let us know if you hit any edge cases.
What you’ll need
Section titled “What you’ll need”- Allow 52.17.120.25 to reach your Redshift workgroup/cluster endpoint on port
5439. - A user with
SELECTon the schemas you want exposed. - Ability to read
information_schemaso we can sync tables/columns.
Fill the form
Section titled “Fill the form”- Display name: Label shown inside Inconvo.
- Host / Port: The workgroup or cluster endpoint and port (
5439by default). - Database: Target database (e.g.,
dev). - Username / Password: Dedicated credentials with least privilege.
- Advanced options → Custom options: Add
sslmode=requireor other parameters you need. We append them to the connection string.
Example:
postgresql://USER:PASSWORD@REDSHIFT-ENDPOINT:5439/DBNAME?sslmode=requireAfter you save
Section titled “After you save”- We deploy the connector and start schema sync; status shows Connecting while it completes.
- Set the user’s default schema (or
search_path) to keep the agent focused on the right objects. - Size your WLM/AutoWLM queue so read-only reporting queries have enough concurrency.