Share via

Workday Reports connector reference

  • Article

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; …”