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.