Google BigQuery Reader: Format Parameters
To access feature type parameters, click the gear icon on a feature type in the workspace to open the Feature Type Parameter Editor. To always display the editor in Workbench, you can select View > Windows > Parameter Editor.
All feature types share similar General Parameters. This includes Name and Writer Name. From here, you can also control Dynamic Properties.
These parameters apply only to a selected feature type, not to the entire reader.
Note: If a feature type parameter corresponds to a reader-level parameter, then the reader parameter will be ignored and the feature type parameter will be used.
The SQL WHERE clause to restrict which data is read.
This controls whether existing data in the destination table will result in appending, overwriting, or failure.
- WRITE_EMPTY
- WRITE_APPEND
- WRITE_TRUNCATE
Only applies if a destination table has been chosen. Causes the normal restrictions on large volumes of data to be ignored.
In addition to being output as features, the results will stored in this table.
Specifies whether the BigQuery cache from previous queries will be used, if possible. When a query is satisfied by the cache, you will not be billed for any usage. Caching cannot be enabled when a destination table has been selected.