Skip to main content

Workday Reports connector reference

Automatic data transformations

Databricks automatically transforms Workday data types to Delta-compatible data types as follows:

Workday type

Delta type

Integer

Decimal(38,18)

Decimal/Float

Decimal(38,18)

Date

Date (no change)

DateTime

Timestamp

String/Text

String (no change)

Boolean

Boolean (no change)

Currency

String

ID / Reference ID

Any object reference is converted to string representation of the entire object.

Multi-instance columns

A string consisting of a string representation of individual objects separated by semicolons. For example, “123 Embarcadero Street; 160 Spear Street; …”