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

Rules and guidelines for dynamic schema handling for mappings and elastic mappings

Rules and guidelines for dynamic schema handling for mappings and elastic mappings

Consider the following rules and guidelines when you enable dynamic schema change handling:
  • Updates to the data types, precision, and scale are not applicable.
  • Schema updates that involve a decrease in the precision of the Varchar data type are not applicable.
  • When you use special characters in a target table column and select
    Alter and Apply Changes
    , the mapping task fails with an error.
  • When you use a completely parameterized filter in a field mapping in a Source transformation and select the
    Dynamic
    option, the
    Schedule
    page does not display the options to refresh the schema.
  • When you use an SQL override in a Source transformation and select
    Alter and Apply Changes
    , the mapping task fails with an error.
  • When you add a field in the source as a primary key and select
    Alter and Apply Changes
    , the mapping task runs successfully and the field is propagated to target. However, the primary key is not considered.
  • When you override the source table name or schema name and select the
    Alter and Apply Changes
    schema change handling option, and if new fields are added to the overridden source table, the mapping runs successfully. However, the Secure Agent does not fetch the newly added fields from the overridden source table.