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

Mappings in SQL ELT mode for Google BigQuery

Mappings in SQL ELT mode for
Google BigQuery

You can create mappings in SQL ELT mode to read data from
Google BigQuery
, Google Cloud Storage, or Amazon S3, load it to
Google BigQuery
, and perform all of the data transformation within
Google BigQuery
.
To create a mapping in SQL ELT mode, you create a mapping, and then select
Mapping - SQL ELT
as the mapping type. You are then prompted to choose a
Google BigQuery
target connection. If your organization doesn't have any
Google BigQuery V2
connection, you are prompted to create one. After you choose the target connection, the Mapping Designer opens. When you create a mapping, a Source transformation and a Target transformation are already on the canvas for you to configure.

0 COMMENTS

We’d like to hear from you!