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 data 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.