For each organization, Dremio imposes limits on the use of its resources. The following limits are grouped according to Dremio components.
Please contact Dremio to discuss if extra capacity is required.
Organization
| Item | Enterprise |
|---|
| Number of projects | 200 |
| Enterprise identity providers | 1 |
| Number of users | 15,000 |
| User invitations at once | 10 |
| Pending user invitations | 100 |
| Daily user invitations | 100 |
| Number of custom roles | 5,000 |
| Layers of nested roles | 10 |
| Direct custom role members | 1,000 |
Projects
| Item | Enterprise |
|---|
| Number of engines | 50 |
| Number of sources | 100 |
| Folder nesting depth | 8 |
| Number of tables | Unlimited |
| Number of views | Unlimited |
| Number of scripts per user | 1,000 |
| ACLs update rate per minute | 600 |
Catalog
| Item | Enterprise |
|---|
| Open Catalog entity name length | 500 characters |
AI Agent
| Item | Enterprise Trial | Enterprise Paid |
|---|
| Files per message | 10 | 10 |
| Maximum file size | 500 MB | 500 MB |
| File availability | 10 minutes | 10 minutes |
| Custom instructions length | 5,000 characters | 5,000 characters |
| Skills per user | 20 | 20 |
| Skill name length | 100 characters | 100 characters |
| Skill description length | 1,024 characters | 1,024 characters |
| Skill instructions length | 25,000 characters | 25,000 characters |
Engines
| Item | Enterprise |
|---|
| Replica sizes | 2XS, XS, S, M, L, XL, 2XL, 3XL |
| Number of replicas | 100 |
| Query concurrency | The query concurrency limits are determined by the replica sizes as described in Engines. |
| Query runtime max limit | Min 30 seconds |
Datasets
| Item | Enterprise |
|---|
| Metadata refresh time - data lake | 15 minutes |
| Metadata refresh time - RDBMS | 1 hour |
| Reflection refresh frequency | 1 hour |
| Wiki character limit | 100k characters |
| Number of JSON files | 300,000 |
| Row width | 16 MB |
| File upload size | 500 MB |
Reflections
| Item | Enterprise |
|---|
| Maximum number of Reflections (including enabled and disabled Reflections) | 500 |
| Autonomous Reflections | 100 |
Arrow Flight SQL (ADBC, ODBC, and JDBC)
| Item | Enterprise |
|---|
| Max returned data volume | 10GB |
| Flight Service Data Pipeline Drain Timeout | 50 seconds |
Rate Limits
Rate limits are enforced on a single IP address and apply across all organizations and projects.
| Item | Enterprise |
|---|
| Login rate per user per second | 100 |
| SCIM reads per minute - user | 180 |
| SCIM writes per minute - user | 300 |
| API calls per minute | 1,200 |
API: /job/{id}/results calls per minute | 1,000 |
API: /job/{id}/cancel calls per minute | 100 |
API: /job/{id} calls per minute | 100 |
API: /login/userpass calls per second | 45 |
| Access control list update rate per minute | 60 |