Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Data type reference overview

Data type reference overview

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.