Google BigQuery Reader: Format Parameters
To access feature type format parameters, open the Feature Type Properties dialog by clicking the properties button on a feature type in the workspace.
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.