Skip to main content

Amazon Redshift

Amazon Redshift is a cloud data warehouse product offered by Amazon Web Services. It can be used as a downstream resource in your Turbine streaming apps by using the write function to a select table in a database.

Setup

Resource Configuration

Use the meroxa resource create command to configure your Amazon Redshift resource.

The following example depicts how this command is used to create an Amazon Redshift resource named warehouse with the minimum configuration required.

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

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

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

Configuration Options

The following configuration is supported for this resource:

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