Whether to split WQL data sources into multiple tables.

Syntax

Connect-Workday -UseSplitTables SwitchParameter

Data Type

bool

Default Value

false

Remarks

Workday data sources will 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 cmdlet exposes the data sources the same way Workday does, so tools with these limitations cannot use larger data sources.

Enabling this option allows the cmdlet to be used with these tools. When split tables are enabled, the cmdlet creates multiple tables for complex Workday data sources. 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.

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