Amazon Redshift cloud data source
This article describes how to set up the 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:
| 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 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.
This page was last updated: April 1, 2026