Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with Snowflake Data Cloud Connector
  3. Part 2: Data Integration with Snowflake Data Cloud Connector
  4. Part 3: SQL ELT with Snowflake Data Cloud Connector
  5. Appendix A: Data type reference
  6. Appendix B: Additional runtime configurations
  7. Appendix C: Upgrading to Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Migrate mappings containing advanced filter and a table name override

Migrate mappings containing advanced filter and a table name override

If the mapping contains an advanced filter for the object, for example, <Table2>, in the query options section and an override to the table name in the advanced properties, consider the following rules to override the table:
In mappings, consider one of the following options:
  • The advanced filter in the mapping must include the
    $$Filtercondition
    value. In the mapping task, you can override the value from the parameter file in the task properties. The parameter condition in the parameter file must include the following condition:
    $$Filtercondition =<Table2>.id >= 1
  • Use the table name that you specify as an override in the advanced properties directly in the advanced filter condition. For example,
    <Table2>.id >= 1
    .
In advanced mode, use the table name specified as an override in the object advanced properties directly in the advanced filter condition. For example,
<Table2>.id >= 1
.

0 COMMENTS

We’d like to hear from you!