BigQuery
Export single table to GCS
Overview
This BLOCK exports data from a single BigQuery table as a file and saves it to Google Cloud Storage (GCS).
Properties
| Property | Explanation |
|---|---|
| BLOCK name | Configure the name displayed on this BLOCK. |
| GCP service account | Select the GCP service account to use with this BLOCK. |
| Destination file GCS URL |
Designate the URL for the file in GCS to which data from the BigQuery table will be exported. This URL should be formatted as Supports % format characters and variable expansion. |
| Source dataset |
Designate the ID of the dataset containing the table whose data will be exported as a file. Supports % format characters and variable expansion. |
| Source table |
Designate the ID of the table whose data will be exported as a file. Supports % format characters and variable expansion. |
| 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 a format for the file you will export. Permissible formats are as follow.
|
| CSV delimiter character |
Select the delimiter character used for CSV files.
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 file.
|