Redshift

Redshift connects via the Postgres family.

At a glance

Setup

1. Open Connect source

   In the app, go to Data sources and choose Connect source. Open the Warehouses tab and select Redshift.

2. Enter connection details

   Provide the host, port, database name, and a read-only user and password. The default port is 5439. Enable SSL/TLS if your database requires it, or configure an SSH tunnel for a private network.

3. Save the connection

   Queringo tests the connection before saving, then discovers the schema. PII is flagged and masked by default during discovery.

Where to find these in your provider

1. In the AWS console, open your Redshift cluster.
2. Create a read-only user from the query editor: CREATE USER queringo PASSWORD '…';
3. Grant SELECT on the schemas and tables you want exposed.
4. Open the cluster's security group to allow Queringo's outbound IP on port 5439, or use VPC peering for a private route.

Test the connection

Queringo runs a connection test as part of saving. If it fails, the error message indicates what to check (credentials, network reachability, or scope). From Data sources, you can re-run Test connection on the source row any time, for example after rotating a secret or changing network rules.

Edit or rotate

To change connection details (host, port, or database), open the source from Data sources and edit it. To swap only the secret (password, key file, or token), use Rotate credentials so existing dashboards and alerts keep working. See Rotating credentials.

Reference

• Redshift: CREATE USER

Suggest a different connector

Don't see what you need? In the Connect a data source picker, choose Request it. Queringo bundles votes from every workspace asking for the same one and prioritizes accordingly.

Related connectors

• BigQuery
• ClickHouse
• Databricks SQL
• DuckDB

What's next

For the category overview and shared options, see Warehouses. To keep sources healthy, see Managing sources.