Getting started with the Amazon Redshift database

Amazon Redshift database

This page contains basic information to help you start working with Amazon Redshift.

Connect to your data

The database structure can be fully reverse-engineered and stored in xDI Metadata. You can then use it when designing mappings and processes to adapt your business rules according to your requirements.

Refer to Connect to your data for more information.

Work with mappings

Refer to Work with mappings for more information.

Deserialize Redshift string as JSON

Overview

The deserializer Redshift String as Json allows you to parse JSON data contained in a source Redshift database column.

See Deserialize source data.

There is a known limitation when the json structure has objects with capital letters in their names.

Check what is the default database configuration in regards of enable_case_sensitive_identifier: * If enable_case_sensitive_identifier is set to true the template will work fine.

  • If enable_case_sensitive_identifier is set to false by default, you have the following options:

    • Add a Connection Initialization SQL Script on the metadata with set command to set enable_case_sensitive_identifier to true. Refer to Define connection initialization SQL scripts for more information. Note this will apply to all the connections and mappings using the concerned metadata (even those that do not use the deserializer)

    • Alternatively, you can set enable_case_sensitive_identifier to true by putting an SQL operation before the mapping (in a named transaction for example) and configure the mapping to be executed in the same transaction. Note that the set command applies to the current session. So if there are other processes using the same connection pool at the time of execution, the setting will affect them as well.