Databricks User Attributes

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:

The following table shows the attribute types that are supported.

Name The name of the field to be written.
Type

This format supports the following field types.

bigint

This type is used to represent 64-bit signed integers.

binary

Represents binary data with a maximum length of 8 MB.

boolean

Represents boolean data.

date

Represents single date data types with no time elements.

See Standard FME Date/Time Format.

decimal (p, s)

Represents numbers with maximum precision p and fixed scale s.

double

Represents 64-bit double-precision floating point numbers.

float

Represents 32-bit single-precision floating point numbers.

int

Represents 32-bit signed integer numbers.

smallint

Represents 16-bit signed integer numbers.

string

Represents character string values.

timestamp

This type is used to represent time data with a precision of up to 1 nanosecond.

See Standard FME Date/Time Format.

tinyint

Represents 8-bit signed integer numbers.

array

Represents values comprising a sequence of elements.

map

Represents values comprising a set of key-value pairs.

struct

Represents values with the structure described by a sequence of fields.

Note  FME treats array, map, and struct columns as JSON.

Index

NotNull

The writer supports creating new tables with non-null fields, which can be done by setting the Index to NotNull.

For existing tables, the writer will enforce NOT NULL constraints even if this column is not set.