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