Amazon Redshift Connectors

Back Next

Data type reference

Data Integration

uses the following data types in

synchronization

tasks, mappings, and

mapping

tasks with Amazon Redshift:

Amazon Redshift Native Data Types: Amazon Redshift data types appear in the Source and Target transformations when you choose to edit metadata for the fields.
Transformation Data Types: Set of data types that appear in the transformations. They are internal data types based on ANSI SQL-92 generic data types, which the runtime environment uses to move data across platforms. Transformation data types appear in all transformations in
synchronization
tasks, mappings, and
mapping
tasks.; When
Data Integration
reads source data, it converts the native data types to the comparable transformation data types before transforming the data. When
Data Integration
writes to a target, it converts the transformation data types to the comparable native data types.