Amazon Redshift

Load event data into Amazon Redshift for petabyte-scale data warehousing and analytics.

Configuration

FieldTypeRequiredDescription
cluster_idstringYesThe Redshift cluster identifier.
databasestringYesThe target database name within the cluster.
schema_namestringYesThe schema to write to. Defaults to public.
table_namestringYesThe target table name to insert rows into.
iam_role_arnsecretYesIAM role ARN with Redshift Data API permissions.
regionselectYesThe AWS region where the Redshift cluster is located.

Quick Setup

  1. Navigate to Integrations in the sidebar.
  2. Open the Integration Library tab.
  3. Find Amazon Redshift or filter by Cloud Storage.
  4. Click Install, select a variant if available, and fill in the required fields.
  5. Click Install Integration to create the integration with a ready-to-use default configuration.

API Setup

curl -X POST http://localhost:8084/v1/admin/integration-catalog/amazon_redshift/install \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Amazon Redshift",
    "variant": "default",
    "config": {
      "cluster_id": "my-redshift-cluster",
      "database": "analytics",
      "schema_name": "public",
      "table_name": "events",
      "region": "us-east-1"
    },
    "delivery_mode": "server_side"
  }'

Delivery

Events are delivered server-side from your Datafly Signal infrastructure directly to Amazon Redshift. No client-side scripts are loaded for this integration.

Visit Amazon Redshift documentation for full API documentation and credential setup instructions.