Amazon Redshift cloud data source

The Amazon Redshift cloud data source is currently in Early Access and is only available to select customers. If you are interested in using Amazon Redshift as a data source, contact your Tealium Support representative.

A cloud data source links your cloud data warehouse or database to Tealium, which lets you import database rows as events.

For more information, see About cloud data sources.

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:

Amazon Redshift	Tealium
Numeric types	Number attributes
Strings, multibyte characters, SUPER, and VARBYTE types	String attributes
Boolean type	Boolean attributes
Datetime types	Date attributes

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 mode

For a general overview, see Query modes.

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

For more information, see Amazon Redshift: TIMESTAMP.

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

WHERE clause

For a general overview, see SQL Query.

The WHERE clause does not support subqueries from multiple tables. To import data from multiple Amazon Redshift tables, create a view in Amazon Redshift and select the view in the data source configuration.