The Manage Limits view allows you to view and set limits for features such as throttling, logging, and SQL auditing.

In the Manage Limits view, limits can be set at either the system or tenant level. System limits apply to behavior across Hybrid Data Pipeline and override default behavior, while tenant limits apply to the resources of a given tenant and override default behavior and system limits. Most limits can only be configured at the system level. However, some limits, such as MaxFetchRows and MaxConcurrentQueries, can be configured at any level.

Note:

  • Tenant limits can also be set via the Manage Tenants view.
  • Limits can also be specified for users and data sources. User limits can be set either through the Manage Users view or the Limits API. User limits override default, system, and tenant limits. Data source limits can only be set via the Limits API. Data source limits override all other limits.

The Manage Limits view is available to users with either set of the following permissions.

  • Administrator (12) permission
  • WebUI (8) permission, Limits (27) permission, and administrative access on the given tenant
system limits view

The table below provides descriptions for limits that may be set via the Manage Limits view.

Note:

  • For account lockout limits, see System Configurations view.
  • Throttling limits can be set either for the system tenant or any child tenant across the system.
  • Log Management, Data Usage Meter, and Security limits can only be set for the system.
  • SQL Auditing can be set for the system tenant or for a child tenant. However, the SQLAuditingRetentionDays and SQLAuditingMaxAge limits may only be set at the system level.
  • To set system limits, the system tenant must be selected from the Tenant dropdown. The user must have the Administrator (12) permission.
  • To set tenant limits, the child tenant must be selected from the Tenant dropdown. The user must have either the Administrator (12) permission, or WebUI (8), Limits (27) permissions, and administrative access on the given tenant.
Category Limit Description
Throttling MaxFetchRows Maximum number of rows allowed to be fetched for a single query.
ODataMaxConcurrentPagingQueries Maximum number of concurrent active queries per data source that cause paging to be invoked.
TransactionTimeout The number of seconds the system allows a transaction to be idle before rolling it back.
XdbcMaxResponse Approximate allowed maximum page size of JDBC/ODBC HTTP result data in KB.
ODataMaxConcurrentRequests Maximum number of simultaneous OData requests allowed per user.
ODataMaxWaitingRequests Maximum number of waiting OData requests allowed per user.
ODataCharacterColumnSizeLimit Maximum size for an OData long character column. The allowed range is 32 KB to 1 MB. The default is 32 KB.
ODataIncludeCharacterLongData Expose long character columns in OData Version 4 data sources.
ODataBinaryColumnSizeLimit Maximum size for an OData long binary column. The allowed range is 32 KB to 1 MB. The default is 32 KB.
ODataIncludeBinaryLongData Expose long binary columns in OData Version 4 data sources.
Log Management LogRetentionDays Number of days log files should be retained.
MonitorRetentionDays Number of days monitor details should be retained.
LogAPIMaxFileSize Maximum size in megabytes of the compressed log file to be downloaded. The maximum size allowed is 2048 megabytes.
LogAPITimeout Maximum time after which the request will be timed out in minute.
Data Usage Meter UserMeterRetentionDays Number of days user meter details should be retained.
UserMeterWriteInterval The number of seconds the system waits before scanning sessions for current metrics. A lower setting will result in more rows written to the meter table.
UserMeterMaxAge The number of seconds the system waits before writing out meter records. A lower setting will result in the rows written to the meter table to occur more frequently.
Security OAuthAccessTokenDuration The duration, in minutes, for which a Access token is valid.
OAuthAccessTokenCacheSize Number of oauth access tokens to be cached in memory for OAuth Authentication. By default up to 2000 tokens will be cached in memory.
CORSBehavior Configuration parameter for CORS behavior. Setting the value to 0 disables the CORS filter. Setting the value to 1 enables the CORS filter. Setting the value to 2 enables the CORS filter with the whitelist option.
SQL Auditing SQLAuditing Configuration parameter for SQL statement auditing. Setting the value to 0 disables SQL statement auditing. Setting the value to 1 enables SQL statement auditing.
SQLAuditingRetentionDays The number of days auditing records are retained in the SQLAudit table.
SQLAuditingMaxAge The maximum number of seconds the service waits before inserting the auditing records into the SQLAudit table. A lower setting will increase the frequency with which records are written to the SQLAudit table.