Table of Contents

Search

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

Google BigQuery Connectors

Google BigQuery Connectors

Configuring SQL ELT optimization

Configuring
SQL ELT optimization

To optimize a mapping, add the mapping to a task, and then configure
SQL ELT optimization
in the
mapping
task.
  1. Create a
    mapping
    task.
  2. In the
    SQL ELT Optimization
    section on the
    Runtime Options
    tab, set the
    SQL ELT optimization
    value to
    Full
    or
    To Source
    .
  3. If full
    SQL ELT optimization
    is not available, select how Data Integration handles
    SQL ELT optimization
    in the
    SQL ELT Optimization Fallback Option
    menu:
    • Partial SQL ELT. Default. Data Integration pushes as much transformation logic as possible to the source database. The task processes any transformation logic that it can't push to a database. You can use Partial SQL ELT only when you read from and write to Google BigQuery.
    • Non SQL ELT. The task runs without
      SQL ELT optimization
      .
    • Fail Task. Data Integration fails the task.
    The fallback options are not applicable to mappings in advanced mode.
When you run the mapping task, the transformation logic is pushed to the Google BigQuery database.

0 COMMENTS

We’d like to hear from you!