OPT_LOAD_WITH_BQ_API

Target database: Google BigQuery

OPT_LOAD_WITH_BQ_API is a load option to use Google BigQuery batch loading API instead of ADE default LOAD DATA INTO in SQL in Google BigQuery file loads.

See also:

• Loading source data (guide)

• Load options

• OVERRIDE_FILE_LOAD

• LOAD DATA INTO

• Batch loading data

• Batch loading data options (JSON)

Usage

OPT_LOAD_WITH_BQ_API: Boolean

Default: false

Notes

OPT_LOAD_WITH_BQ_API can be used in file loads.

ADE uses Google Cloud client libraries to utilize batch loading API. Usage is similar to CLI-command bq load.

Examples

File load with OPT_LOAD_WITH_BQ_API:

OPT_LOAD_WITH_BQ_API: True

File format options can be defined with OPT_FILE_FORMAT_OPTIONS. Example values in JSON-format to load NEWLINE_DELIMITED_JSON with GZIP-compression:

{
  "sourceFormat": "NEWLINE_DELIMITED_JSON",
  "compression": "GZIP"
}

See all the possible values from Google documentation.