Amazon Redshift Connector
Connector implementation
Build the Amazon Redshift integration
Cloud data warehouse service for petabyte-scale analytics with SQL and BI tool integration
Implementation Overview
Implement an Amazon Redshift connector that authenticates to the vendor surface, normalizes source records in Tajo, and activates eligible data in Brevo.
Treat this as an implementation guide. Build and validate the auth, mapping, sync, and operations paths before production use.
docs.aws.amazon.com/redshift/latest/mgmt/data-api.html
| Property | Value |
|---|---|
| Integration surface | Docs |
| Implementation status | Implementation required |
| Category | Data Warehouses |
| Setup complexity | advanced |
| Vendor documentation | docs.aws.amazon.com/redshift/latest/mgmt/data-api.html |
| Allowed host | Not recorded |
| Base URL | Not recorded |
| OpenAPI schema | Not recorded |
| MCP server | Not recorded |
| Last researched | 2026-08-19 |
AWS does not publish OpenAPI for Redshift; uses AWS SDK conventions. An official AWS Labs Redshift MCP server exists but is local/stdio-only, not a hosted remote MCP, so it does not change status.
Authentication
-
Keep docs.aws.amazon.com/redshift/latest/mgmt/data-api.html linked from the connector runbook so operators can confirm vendor behavior during incidents.
-
Store credentials per Tajo workspace and keep tenant-specific secrets out of connector configuration files.
-
Add a credential smoke test that verifies read access to a harmless resource before running backfills or enabling webhooks.
Data To Sync
Start with these inferred data domains, then confirm exact vendor resources and permissions from the source documentation:
- Events, webhooks, and behavioral activity
- Custom objects and operational metadata
The connector should make source records idempotent by keeping a stable key such as a vendor object ID, email address, event ID, ticket ID, order ID, or campaign ID. If the vendor only exposes list APIs, Tajo should store the cursor strategy and replay policy explicitly.
Sync Shape
No typed contract exists for Amazon Redshift, so the direction of each resource and its conflict handling are not recorded. Direction is declared per resource on a connector contract; see the connector catalog for how contracts are promoted.
Mapping To Tajo/Brevo
No Brevo projection is recorded for Amazon Redshift. A projection is declared on a typed connector contract, and Amazon Redshift does not have one yet, so this page will not state a mapping it cannot source.
The conventions that apply to every connector — stable external IDs, normalization, backfill and sync strategy, error handling, and the builder checklist — are documented once under “Applies to every connector” on the connector catalog.