Split WQL data sources into multiple tables.

Data Type

bool

Default Value

false

Remarks

Workday data sources often have several hundred fields, with some data sources like allWorkers having thousands of fields.

Many database and reporting tools do not support tables with this many columns.

By default, the provider exposes all of a data source's fields, so tools with these limitations cannot use larger data sources.

When this connection property is set to True, the provider creates multiple tables for complex Workday data sources, allowing tools with limitations on the total column number to display all of the data source columns.

Each split table contains between 50-100 columns, along with the primary key, last modified timestamp and effective and entry inputs.

JOINs can be used if data is required from columns that are part of different split tables. For example:

SELECT a.academicDegree, b.yearsExperience
FROM allWorkers_1 a INNER JOIN allWorkers_60 b
ON a.workdayID = b.workdayID