Amazon Redshift Feature Representation

Features read from Redshift consist of a series of attribute values only and no geometry. The feature type of each feature is as defined in its Feature Type parameters, but the only type used is redshift_none. Underlying Redshift geometries are not read as geometries, but are interpreted as strings.

Features written to the database have the destination table as their feature type, and attributes as defined on the DEF line.

In addition to the generic FME feature attributes that FME Workbench adds to all features (see About Feature Type Attributes), this format also adds format-specific attributes (Format Attributes).

Attribute Name Contents
redshift_type

The type of geometric entity stored within the feature. The valid value for the object model is:

  • redshift_none

Features read from, or written to, Redshift have an attribute for each column in the database table. The feature attribute name will be the same as the source or destination column name. The attribute and column names are case-sensitive.

No Coordinates

redshift_type: redshift_none

Features with no coordinates are tagged with this value when reading or writing to or from Redshift. This is the default.