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