Workday reports connector reference

Preview

LakeFlow Connect is in gated Public Preview. To participate in the preview, contact your Databricks account team.

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