ExpandMultiValueLimit
The maximum number of output rows that can be expanded from a single input row.
Data Type
int
Default Value
500
Remarks
When using ExpandMultiValues, the provider can generate multiple output rows for each input row from Workday. Each multi-value column included in the query increases the number of output rows exponentially. For example, if a table has five array columns and has one row has three values for each, then rows are generated in this pattern:
| Number of Array Columns Selected | Number of Output Rows |
| 0 | 1 |
| 1 | 3 |
| 2 | 9 |
| 3 | 27 |
| 4 | 81 |
| 5 | 243 |
Realistic queries can output thousands of rows which can be expanded into hundreds of thousands of output rows. Generating these rows reduces the provider's performance and can potentially cause the provider to run out of memory.
To avoid this, the provider counts the number of output rows before actually generating them. If any input row would generate more rows than the ExpandMultiValueLimit, the provider reports an error instead. When this happens you should carefully evaluate the query and remove any array columns that are not required. Only increase this limit if there is no way to simplify your query.