Google BigQuery Connectors

Back Next

SQL ELT optimization scenarios

SQL ELT optimization
scenarios

You can configure

SQL ELT optimization

for the following scenarios in mappings:

To configure

SQL ELT optimization

using the Google BigQuery V2 Connector, verify that your organization has the Mappings-Advanced SQL ELT Optimization
license. To get the license, contact Global Customer Support.

Source and target endpoints	Supported SQL ELT optimization scenarios in mappings	SQL ELT optimization type
Google BigQuery source Google BigQuery target	Reads from and writes to Google BigQuery using the Google BigQuery V2 connection.	Full, Source
Google Cloud Storage source Google BigQuery target	Reads from Google Cloud Storage using a Google Cloud Storage V2 connection and writes to Google BigQuery using a Google BigQuery V2 connection.	Full
Amazon S3 source Google BigQuery target	Reads from Amazon S3 using an Amazon S3 V2 connection and writes to Google BigQuery using a Google BigQuery V2 connection.	Full
You can use the Secure Agent or the Hosted Agent to run mappings enabled with SQL ELT optimization .