Skip to main content
Skip table of contents

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:


Usage

OPTION
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:

OPTION
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:

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

See all the possible values from Google documentation.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.