Limits

For each organization, Dremio Cloud imposes limits on the use of its resources. Limits are grouped according to Dremio components, as follows:

• Organization
• Arctic
• Project
• Engine
• Datasets
• ODBC/JDBC/Flight

Organization

Item	Standard Edition Limit	Enterprise Edition Limit
Number of clouds	3	100 *
Number of projects	3	200 *
Enterprise IdPs	Not supported	1
Number of users	10	15,000
Layers of nested roles	Not supported	10
Direct role members	Not supported	1,000
Login rate per user per second	100	100
SCIM reads per minute - organization-wide	Not supported	600
SCIM writes per minute - organization-wide	Not supported	1,000
SCIM reads per minute - user	Not supported	180
SCIM writes per minute - user	Not supported	300
ACLs update rate per minute	1	60
REST API calls per minute	120	1,200
REST API - /login/userpass per user per second	45	45

* Please contact Dremio to discuss if extra capacity is required.

Arctic

Item	Standard Edition Limit	Enterprise Edition Limit
Number of primary catalogs	3	32
Data retention period for VACUUM	1 day	90 days

Project

Item	Standard Edition Limit	Enterprise Edition Limit
Number of engines	5	50
Number of sources	10	100
Folder nesting depth	4	8
Number of tables	200	Unlimited
Number of views	1,000	Unlimited
Number of scripts per user	1,000	1,000
ACLs update rate per minute	10	600

Engine

Item	Standard Edition Limit	Enterprise Edition Limit
Replica sizes	2XS, XS, S	2XS, XS, S, M, L, XL, 2XL, 3XL
Number of replicas	2	100
Query concurrency	40	100
Query runtime max limit	Min 30s	Min 30s

Datasets

Item	Standard Edition Limit	Enterprise Edition Limit
Metadata refresh time - data lake	1 day	15 minutes
Metadata refresh time - RDBMS	1 day	1 hour
Reflection refresh frequency	6 hours	1 hour
Wiki character limit	100k characters	100k characters
Number of JSON files	10,000	300,000

ODBC/JDBC/Flight

Item	Standard Edition Limit	Enterprise Edition Limit
Max returned data volume	100MB	10GB