Skip to main content

Amazon Redshift

The Meroxa Platform will automatically discover the version, capabilities, and permission of the added Redshift Resource and will create the appropriate connection to capture data changes or use it as a destination.

Adding Resource#

To add a Postgres resource to your Meroxa Resource Catalog, you can run the following command:

Next, you'll need to add a Redshift Resource to the Meroxa Resource Catalog as the destination of our data.

meroxa resource add warehouse --type redshift -u \"redshift://$REDSHIFT_USER:$REDSHIFT_PASS@$REDSHIFT_URL:$REDSHIFT_PORT/REDSHIFT_DB

warehouse is a human-friendly name to represent the resource within Meroxa. Feel free to change as desired.

In the command above, replace the following variables with valid credentials from your Postgres environment:

  • $REDSHIFT_USER - Redshift Username
  • $REDSHIFT_PASS - Redshift Password
  • $REDSHIFT_URL - Redshift URL
  • $REDSHIFT_DB - Redshift Database Name
  • $REDSHIFT_PORT - Redshift Port (e.g., 5432).

Destination Configuration#

The Redshift Destination Connector allows you to load Data Records from a Streams into a Redshift Table.

To configure Redshift as a destination:

meroxa connector create to-redshift --to warehouse --input $STREAM_NAME

The command above creates a new Connector called to-redshift, sets the destination to a resource named warehouse, and configures the input with a Stream .

Configuration Options#

The following configuration is supported for this Connector:

ConfigurationDestination
table.name.formatA format string for the destination table name, which may contain '${topic}' as a placeholder for the originating stream name.