Google BigQuery Connectors

Back Next

Sources in mappings in SQL ELT mode

When you configure the source connection in the Source transformation, you can choose only an Amazon S3 V2, Google BigQuery V2, or Google Cloud Storage V2 connection.

Google BigQuery V2 source properties

You can configure the following advanced properties for a Google BigQuery V2 source:

Source Dataset ID

Source Table Name

SQL Override Query

Google Cloud Storage V2 source properties

You can configure the following advanced properties for a Google Cloud Storage V2 source:

Google Cloud Storage Path

Source File Name

Is Directory

For more information on how to configure the supported properties, see the Google Cloud Storage V2 Connector documentation.

Amazon S3 V2 source properties

You can configure the following advanced properties for an Amazon S3 V2 source:

Source Type

Folder Path

File Name

For more information on how to configure the supported properties, see the Amazon S3 V2 Connector documentation.

For more information on how the sources in mappings in SQL ELT mode behave differently from the sources in other types of mappings, see the Sources in mappings in SQL ELT mode topic in

Mappings

in the Data Integration help.

Mappings in SQL ELT mode for Google BigQuery

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal