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 on its DEF line 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 Attributes), this format adds the format-specific attributes described in this section.

Attribute Name Contents
redshift_type

The type of geometric entity stored within the feature. The valid values for the object model are listed below:

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.