Google BigQuery Writer: Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace. This opens the Feature Type Parameter Editor.

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.

Important  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.

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.