For each organization, Dremio Cloud imposes limits on the use of its resources. The following limits are grouped according to Dremio components.
Organization
| Item | Standard Edition Limit | Enterprise Edition Limit |
|---|
| Number of clouds | 3 | 100 * |
| Number of projects | 3 | 200 * |
| Number of Arctic catalogs | 3 | 128 |
| Enterprise IdPs | Not supported | 1 |
| Number of users | 10 | 15,000 |
| User invitations at once | 2 | 10 |
| Pending user invitations | 5 | 100 |
| Daily user invitations | 5 | 100 |
| Layers of nested roles | Not supported | 10 |
| Direct role members | Not supported | 1,000 |
* Please contact Dremio to discuss if extra capacity is required.
Arctic
| Item | Standard Edition Limit | Enterprise Edition Limit |
|---|
| Data retention period for VACUUM | 1 day | 90 days |
Projects
| 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 |
Engines
| 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 | The query concurrency limits are determined by the replica sizes as described in Instance Types. |
| Query runtime max limit | Min 30 seconds | Min 30 seconds |
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 |
| Row width | 16 MB | 16 MB |
Reflections
| Item | Standard Edition Limit | Enterprise Edition Limit |
|---|
| Maximum number of Reflections (including enabled and disabled Reflections) | 500 | 500 |
Arrow Flight SQL (ADBC, ODBC, and JDBC)
| Item | Standard Edition Limit | Enterprise Edition Limit |
|---|
| Max returned data volume | 100MB | 10GB |
| Flight Service Data Pipeline Drain Timeout | 50 seconds | 50 seconds |
Rate Limits
Rate limits are enforced on a single IP address and apply across all organizations and projects.
| Item | Standard Edition Limit | Enterprise Edition Limit |
|---|
| Login rate per user per second | 100 | 100 |
| SCIM reads per minute - user | Not supported | 180 |
| SCIM writes per minute - user | Not supported | 300 |
| API calls per minute | 120 | 1,200 |
API: /job/{id}/results calls per minute | 120 | 1,000 |
API: /job/{id}/cancel calls per minute | 100 | 100 |
API: /job/{id} calls per minute | 100 | 100 |
API: /login/userpass calls per second | 45 | 45 |
| Access control list update rate per minute | 1 | 60 |