To help ensure consistent performance, Wdata's features and Developer Application Programming Interface (API)—which enables custom integration to connect your data with the Workiva platform—enforce several limits.
Feature Limits
Features in Wdata—such as tables and queries—enforce a number of constraints.
Tables
Feature | Limit |
---|---|
File Upload | CSV or TSV, up to 1G. To reduce the size of an upload, use a ZIP file. |
Columns per Table | 150 |
Records per Dimension Table | 2,000,000 |
Queries
Feature | Limit |
---|---|
Parameters per Query | 30 |
Query Parameter Name | 256 characters |
Items per Parameter Pick List | 512 |
Query SQL Editor Statement | 30,000 characters |
Connections per Spreadsheet, Document, or Presentation | 30 |
Cells per Spreadsheet | 2,000,000 |
UNION Operators in SQL Editor |
20 |
Views
Feature | Limit |
---|---|
Query Rows per View | 1,000,000 |
Chains
Feature | Limit |
---|---|
Connections | One provided with a Solution subscription; five with Enterprise. To purchase additional connections, contact your Customer Success manager. |
Variables | 100 per chain |
Rate Limits
The API may rate limit your requests based on current system load or excessive frequency.
Request | Limit per Minute per Workspace |
---|---|
Upload File | 50 |
Import File | 30 |
List Children | 50 |
Get Files By Size | 10 |
Get Query Usage | 55 |
Get Upload Usage | 5 |
Import Data | 5 |
Export Data | 5 |
Validate Tables | 5 |
Validate Files | 5 |
Delete Workspace | 5 |
Create Edge | 15 |
Update Edge | 15 |
Delete Edge | 30 |
List Edges | 105 |
Get Edge | 5 |
Create Parameter | 10 |
Get Parameter | 10 |
List Parameters | 10 |
Update Parameter | 10 |
Delete Parameter | 10 |
List Pivot Views | 50 |
Update Pivot View | 10 |
Delete Pivot View | 10 |
Get Pivot View | 50 |
Create Pivot View | 10 |
Get Pivot View Query Result | 20 |
Create Query | 57 |
Get Query | 1139 |
Get Query Column Data | 255 |
List Queries | 192 |
Update Query | 93 |
Delete Query | 57 |
Run Query | 92 |
Is Query Valid | 255 |
Get Query Result | 576 |
List Query Results | 39 |
Download Query Result | 10 |
Export Query Result to Spreadsheets | 20 |
Get Dependencies | 10 |
Run Report | 203 |
Get Runs | 126 |
Get Run | 515 |
Create Select List | 36 |
Get Select List | 108 |
List Select Lists | 10 |
Update Select List | 12 |
Delete Select List | 10 |
List Sources | 545 |
List Services | 5 |
List Tags | 50 |
Update Tag | 10 |
Create Tag | 10 |
Delete Tag | 10 |
Create Shared Table | 8 |
Get Shared Table | 366 |
List Shared Tables | 90 |
Delete Shared Table | 2 |
Create User Preference | 25 |
Get User Preference | 50 |
Parse Date | 10 |
If you exceed these limits, you'll receive an error response with a status code of 429 Too Many Requests
.
Request Timeouts
The API limits the length of any request to 10 minutes.
Storage and Querying Limits
The API currently limits the size of lifetime storage and annual querying, depending on your subscription level.
Subscription | Lifetime Storage | Annual Querying |
---|---|---|
Solution | 100GB | 120TB |
Enterprise | 500GB | 3,000TB |
For example, 1GB storage over five years can contain 8M records, including:
- Monthly actuals cut by 10 dimensions
- Monthly rolling 12-month forecasts
- Budget data
We recommend you choose a subscription level based on your storage or querying needs. For example:
- With a Solution subscription, you can query a table with 100GB of data 1,200 times a year; or a table with 50GB of data, 2,400 times a year.
- With an Enterprise subscription, the 3,000TB querying limit enables you to query data 3M times a year.
Note: From Configuration , workspace owners can track usage to verify your organization if within these limits. To purchase additional lifetime storage, contact your Account Owner or Customer Success Manager.
Encryption
To ensure data privacy and integrity, API calls use Transport Layer Security (TLS) 1.2; Advanced Encryption Standard (AES) 256 at rest.