Amazon Redshift cloud data source

For a general overview of setting up a cloud data source, see Manage a cloud data source.

Data types

The Amazon Redshift data source supports all Amazon Redshift data types. To ensure data is imported correctly, map the Amazon Redshift data types according to the following guidelines:

For more information, see Amazon Redshift: Data types.

Create a connection

Tealium uses JDBC to connect to Amazon Redshift. This process requires the full JDBC URL, username, and password of your cluster.

The JDBC URL uses the following format:
jdbc:redshift://hostname:port/database

To configure a new connection, enter the following connection details:

• Hostname: The hostname of the Amazon Redshift cluster. For example, examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com
• Port: The port number that you specified when you launched the cluster.
• Database: The database to connect to.
• Schema: The schema to connect to.

After you connect to Amazon Redshift, select a table or view from the Data Selection list.

For more information, see Amazon Redshift: Getting the JDBC URL.

Query configurations

For a general overview, see Query configurations.

For query modes that use Timestamp, the selected timestamp column must be the type TIMESTAMP or TIMESTAMPTZ.

For more information, see Amazon Redshift: TIMESTAMP.

For query modes that use Incrementing, the selected numeric column must be one of the integer types and increment in value for every row added.

For more information, see Amazon Redshift: Integer types.