Skip to content

Amazon Redshift (beta)

Connect Amazon Redshift to Inconvo.

Redshift support is in beta. Let us know if you hit any edge cases.

  • Allow 52.17.120.25 to reach your Redshift workgroup/cluster endpoint on port 5439.
  • A user with SELECT on the schemas you want exposed.
  • Ability to read information_schema so we can sync tables/columns.
  • Display name: Label shown inside Inconvo.
  • Host / Port: The workgroup or cluster endpoint and port (5439 by default).
  • Database: Target database (e.g., dev).
  • Username / Password: Dedicated credentials with least privilege.
  • Advanced options → Custom options: Add sslmode=require or other parameters you need. We append them to the connection string.

Example:

postgresql://USER:PASSWORD@REDSHIFT-ENDPOINT:5439/DBNAME?sslmode=require
  • 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.