Readers: For information on the parameters in this dialog that are common to all readers, see:
Writers: For information on the parameters in this dialog that are common to all writers, see:
User attributes for this format are defined below.
|
Name |
The name of the column to be written. |
|
Type |
The type of a column in a table. The valid values for the column type are listed below: binary Represents binary data with a maximum length of 8 MB. binary(width) Represents binary data, with a maximum length of the specified width up to 8 MB. boolean Represents boolean data. date Represents single date data types with no time elements. See Standard FME Date/Time Format. float Represents a 64-bit double-precision number. geography Represents ellipsoidal spatial (round-earth) data in an LL-WGS84 coordinate system. geometry Represents features in a planar (Euclidian, Cartesian) coordinate system. FME does not yet support coordinate systems within Snowflake geometry. number Represents numbers up to 38 digits. time This type is used to represent time data with a precision of up to 1 nanosecond. See Standard FME Date/Time Format. timestamp_ntz This type is used to represent date and time data from January 1, 0001 to December 31, 9999 with an accuracy of up to 1 nanosecond. Time zone information is not stored. See Standard FME Date/Time Format. varchar Represents unicode characters, with a maximum length of 16 MB. varchar(width) Represents unicode characters, with a maximum length of the specified width up to 16 MB. variant Represents semi-structured data with a maximum length of 16MB compressed. Note When writing to variant columns, FME treats variant columns as JSON. We recommend validating the JSON using the AttributeValidator transformer, since an invalid JSON will cause translation failure.
|
|
Index |
The types of indexes and constraints to create for the column. Indexes and constraints are only created if the table is created. Each index and constraint contains only one column. The valid values for the column type are listed below:
|