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; …") |