Google BigQuery Writer: Feature Type Parameters
|
To access feature type parameters, click the gear icon Tip To always display the editor in FME Workbench, you can select View > Windows > Parameter Editor.
General All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry. In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type. |
These parameters apply only to a selected feature type, not to the entire reader.
Write Options
Define the how features are loaded into Google BigQuery.
Table Handling
- Write if Empty (default) – Load features to table only if the table is empty, or does not exist.
- Append – Load features on a pre-existing table.
- Overwrite – Overwrite the entire table with only the new features. All pre-existing data will be overwritten.
Number of errors allowed
The number of features allowed to error out and be ignored. These features will be skipped and not be loaded onto Google BigQuery.
Must be greater than 0.
Spatial Options
Spatial Type
- None – Google BigQuery will infer and assign data types to columns based on the incoming data
- Geography – A spatial column will be generated from the geometries attached to the loaded features and interpreted in WKT. The column will data type will be set to GEOGRAPHY on Google BigQuery.
Spatial Column Name
With Spatial Type set to Geography, specify the name of the column that will hold GEOGRAPHY type data.
on a feature type in the