Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

Validating a mapping in SQL ELT mode

Validating a mapping in SQL ELT mode

In SQL ELT mode,
Data Integration
validates a mapping using additional rules that don't apply to mappings in other modes.
In SQL ELT mode, validation errors can result due to the following circumstances:
  • The mapping contains multiple flows or pipelines.
  • The mapping contains a transformation that doesn't appear in the Transformations palette in SQL ELT mode. For example, if you paste an unsupported transformation onto the mapping canvas, a validation error occurs.
  • The target connection type or target connection parameter type isn't Snowflake Data Cloud.
  • The target has named fields, but the field mapping is set to
    Manual
    . The field mapping must be
    Automatic
    ,
    Partially Parameterized
    , or
    Completely Parameterized
    .
  • The source connection or source connection parameter type isn't Snowflake Data Cloud, Amazon S3, or Azure Data Lake Storage Gen2.
  • The source and target are in the same cloud data warehouse but they use different connections.
  • The mapping contains a Sequence Generator transformation that isn't directly connected to a downstream Expression transformation or target.
  • A Sequence Generator transformation is connected to multiple downstream transformations or targets.
Validation errors can also occur when there's a problem with the source, target or lookup connection. For more information, see the
Snowflake Data Cloud Connector
guide.

0 COMMENTS

We’d like to hear from you!