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
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.