BLOCKS Reference

Block Reference

BigQuery

Export multiple tables to GCS

This BLOCK exports data from multiple BigQuery tables as multiple files in parallel, and saves them to a file group in Google Cloud Storage (GCS).

Property Explanation
BLOCK name Configure the name displayed on this BLOCK.
GCP service account Select the GCP service account to use with this BLOCK.
Exported files GCS URL

Designate the GCS URL for the exported files as "gs://bucketname/objectname".

[% format character addressable] [variable expansion addressable]

File extension

Designate a file extension for exported files. If omitted, the extension will be determined by the "File format" property.

[% format character addressable] [variable expansion addressable]

Source dataset

Designate the ID of the dataset containing the tables whose data will be exported.

[% format character addressable] [variable expansion addressable]

Source tables

Designate the prefix for the IDs of the tables whose data will be exported.

[% format character addressable] [variable expansion addressable]

BLOCK memos Make notes about this BLOCK.
Reattempts in case of errors Configure the number of attempts to try in case of a request error.
Minimum timeout interval Set the number of seconds to wait for results. If results are not returned during this interval, the time will be doubled for each reattempt until the time set in the “Maximum timeout interval” property is reached.
Maximum timeout interval Indicate the maximum number of seconds to wait for results. The timeout interval will start with the value set in the "Minimum timeout interval" property and double with each reattempt until reaching the value set here.
File format

Select the format of the exported files.

  • CSV
  • NEWLINE_DELIMITED_JSON
CSV delimiter character

Select the delimiter character used for CSV files.

  • Comma
  • Tab
  • Pipe
  • Other

If you choose "Other", specify a delimiter character in the accompanying field.

Output header line Select whether or not to output the header line for CSV files.
File compression

Choose whether or not to compress the exported files.

  • Uncompressed
  • GZIP