Can I connect Amazon Redshift to iDBQuery?

Amazon Redshift connects to iDBQuery through the standard warehouse/database connector, exactly like any other SQL warehouse — there's no proprietary connector or extract to manage.

• You'd connect Redshift by entering the cluster endpoint (host and port), database name and a read-only user, typically reached inside your VPC or over a private link.
• iDBQuery reads the schema, applies its semantic layer to decode terse column names, and adds Redshift to your one live queryable model.
• Then you ask in plain language — *"What's our gross margin by product category year to date?"* — and iDBQuery writes and runs the SQL against Redshift, returning a cited answer, chart or live dashboard.

The payoff versus piping Redshift into a separate reporting stack: iDBQuery queries the warehouse in place and cites every number back to its exact source rows, so answers are auditable instead of a black box. Redshift can be combined in one question with spreadsheets, an operational Postgres database, or SaaS data pulled through the REST API connector — all reasoned over as a single model with no pipeline to build. For teams with strict boundaries, run iDBQuery inside the same VPC as the cluster or fully air-gapped so nothing leaves your environment.