Writer Directives

The suffixes shown are prefixed by the current <WriterKeyword> in a mapping file. By default, the <WriterKeyword> for the Google Fusion Table writer is GOOGLEFUSIONTABLES_OUT.

NC

This directive specifies a Named Connection for OAuth 2.0 authentication to Google Fusion Table private data tables from a specific Google account.

For more information on how the Named Connection is used, please refer to the topic Reader Parameters.

Required/Optional

Required

Mapping File Syntax

<WriterKeyword>_NC <named_connection>

Workbench Parameter

Named Connection

DEF

This section is a Flare snippet. It's used in both Google Fusion Tables formats.

Each Google Fusion table must be defined before it can be written. The general form of a Google Fusion table definition statement is:

GOOGLEFUSIONTABLES_DEF <tableName> \
    [googlefusiontables_create_table (yes|no)] \
    [googlefusiontables_drop_table (yes|no)] \
    [googlefusiontables_truncate_table (yes|no)]	\
    [googlefusiontables_mode (inherit_from_writer|insert|update|delete)]\
    [googlefusiontables_update_key_columns <column1, column2, *>]

The table definition allows control of the table that will be created. If the table already exists, the majority of the googlefusiontables_ parameters will be ignored and need not be given. If the fields and types are listed, they must match those in the database.

If the table does not exist, then the field names and types are used to first create the table. In any case, if a <fieldType> is given, it may be any field type supported by the target database.

The configuration parameters present on the definition line are described in the following table:

Parameter Contents
tableName The name of the table to be written
googlefusiontables_create_table

Specify whether or not to create a new table with the name of the table and columns based on the name and user attribute names and types in the writer feature type.

NO

googlefusiontables_geometry_columns

A comma-separated list of the geometry column names for writing.. These geometry columns will be created for each of the supplied geometry column names when creating a new table or matched against the existing geometry columns when writing to an existing table.

Default: geom

googlefusiontables _drop_table

If the table exists by this name, it should be dropped. Only valid when creating a new table.

NO

googlefusiontables _truncate_table

If the table exists by this name, it should be truncated before any features are written to it. Will result in an empty table if combined with UPDATE or DELETE mode.

NO

googlefusiontables _update_key_columns A comma-separated list of the columns which are matched against the corresponding FME attribute’s values to specify which rows are to be updated or deleted when the writer mode is either UPDATE or DELETE.

Required/Optional

Optional

TRANSACTION_INTERVAL

This statement defines the number of features to be placed in each transaction before a transaction is committed to the database.

If the <WriterKeyword>_TRANSACTION_INTERVAL statement is not specified, then a value of 500 is used as the transaction interval.

Note:  The maximum value is 500.

Required/Optional

Optional

Mapping File Syntax

<WriterKeyword>_Transaction_INTERVAL 500

Workbench Parameter

Transaction Interval

WRITER_MODE

This section is a Flare snippet. It's used in both Google Fusion Tables formats.

Note: For more information on this directive, see the chapter Database Writer Mode.

This directive determines which operations will be performed by default by this writer.

This operation can be set to INSERT, UPDATE or DELETE. The default writer level value for this operation can be overwritten at the feature type or table level. The corresponding feature type def parameter name is called GOOGLE_FUSION_TABLE_MODE. It has the same valid options as the writer level mode and additionally the value INHERIT_FROM_WRITER which causes the writer level mode to be inherited by the feature type as the default for features contained in that table.

If the GOOGLEFUSIONTABLES_WRITER_MODE statement is not specified, then a value of INSERT is given.

Mapping File Syntax

<WriterKeyword>_WRITER_MODE INSERT

Workbench Parameter

Writer Mode