BLOCKS Reference

Block Reference

BigQuery

Export single table to GCS

This BLOCK exports BigQuery tables to files in GCS.

Property name Explanation
BLOCK name Designate a name for BLOCKS. The names will be displayed on the BLOCKS.
GCP service account Select the GCP service account for use with this BLOCK.
Export destination file URL in GCS The URL for the file in GCS receiving exported items is specified as something similar to "gs://bucketname/objectname".
[% format character string addressable] [variable expansion addressable]
Source data set to export Designate an ID for the source data set to export.
[% format character string addressable] [variable expansion addressable]
Source table to export Designate an ID for the source table to export.
[% format character string addressable] [variable expansion addressable]
BLOCK memos Make any comments regarding BLOCKS.
Repetition attempts Designate the number of repetitions to occur in the case of an error or time out in BigQuery.
Minimum duration for time out Indicate how many seconds to wait for a response (time out) in BigQuery. It will double with every repetition. The maximum value for the time increase between repetitions is set under 'Maximum duration for time out" in the properties.
Maximum duration for time out As time outs increase from the "Minimum duration for time out", they reach a maximum value. It is defined in units of seconds.
File format

Select a format for the file you will export. Permissible formats are as follow.

  • CSV
  • NEWLINE_DELIMITED_JSON
CSV delimitation characters

When a file format is CSV, choose, or specify, delimitation characters. Characters that can be used for delimitation are as follow.

  • Comma
  • Tab
  • Pipe
  • Other

If you choose "Other", you can specify the character you wish to use for delimitation in the field next to "Other".

Output header line In the case that "File format" is CSV, you can choose whether or not to have the header line output.
File compression

Choose whether or not to compress exported files.

  • Uncompressed
  • GZIP