Workday Reports connector reference

This page contains reference material for the Workday Reports connector in Databricks Lakeflow Connect.

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	String representation of the object
Multi-instance columns	String representation of the objects separated by semicolons (for example, “123 Embarcadero Street; 160 Spear Street; …”)