To help ensure consistent performance, features in Wdata—such as tables and queries—enforce a number of constraints. In addition, the Wdata Developer Application Programming Interface (API), which enables custom integration to connect your data with the Workiva platform, also enforces its own limits.
|File Upload||CSV or TSV, up to 1G. To reduce the size of an upload, use a ZIP file.|
|Columns per Table||150|
|Parameters per Query||30|
|Query Parameter Name||256 characters|
|Items per Parameter Pick List||512|
|Query SQL Editor Statement||30,000 characters|
|Cells per Spreadsheet||2,000,000|
|Query Rows per View||1,000,000|
|Connections||One provided with a Solution subscription; five with Enterprise. To purchase additional connections, contact your Customer Success manager.|
The API may rate limit your requests based on current system load or excessive frequency.
Note: Other requests are currently unlimited. However, Workiva reserves the right to impose additional limits as necessary to ensure effective performance.
If you exceed these limits, you'll receive an error response with a status code of
429 Too Many Requests.
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|
Note: To purchase additional lifetime storage, contact your Account Owner or Customer Success Manager.
For example, 1GB storage over five years contains 8M records, including:
- Monthly actuals cut by 10 dimensions
- Monthly rolling 12-month forecasts
- Budget data
The 3,000TB annual querying limit enables an Enterprise subscription to query its data 3M times a year.
Tracking Storage and Querying Usage
To verify your organization is within these limits, workspace owners can track query usage and data storage over a period of time. From Configuration , select the Usage tab, and review the stats.
- Query Processing—How much of your annual querying limit was used—overall and on a monthly basis—during a selected 12-month time period
- Lifetime Storage—How much of your lifetime storage was used by all table datasets. To help identify major consumers, you can view your 250 largest datasets and their respective tables and sizes.
Note: To view a dataset's data, click its table's name.
To ensure data privacy and integrity, API calls use Transport Layer Security (TLS) 1.2; Advanced Encryption Standard (AES) 256 at rest.