Google BigQuery Connectors

Back Next

SQL ELT configuration options

You can configure SQL ELT when you want the mapping logic to be processed by your cloud ecosystem.

Configure SQL ELT in one of the following ways:

Create a mapping in SQL ELT mode: In a mapping in SQL ELT mode, you don't have to specify an optimization type. Data Integration pushes the transformation logic by default to the target database. You can also preview data for individual transformations to validate the mapping logic.

When you run a mapping in SQL ELT mode, you can load data from the following data sources to
Google BigQuery
:
Amazon S3
Google Cloud Storage
Google BigQuery

For more information on mappings in SQL ELT mode, see Mappings in SQL ELT mode for Google BigQuery.

Create a mapping: If you want to push some or all the transformation logic, you can add the mapping to a mapping task, and enable
SQL ELT optimization
in the mapping task. Data Integration pushes the transformation logic to the source or target database and processes any transformation logic that is not pushed to the sources and targets.

When you create mappings and enable
SQL ELT optimization
in a mapping task, you can load data from the following data sources to
Google BigQuery
:
Amazon S3
Google Cloud Storage
Google BigQuery

For more information on
SQL ELT optimization
, see SQL ELT optimization for mapping tasks.