Limits

This topic lists the Dremio limits.

Type Limit Description
Catalog 32k Size of fields in records.
Catalog 800 Number of columns in tables.
Source 60,000 Number of splits that can be processed for a single dataset (table) for FileSystem Sources. This limitation may be lifted using the unlimited splits capability available in Dremio 18.0+.
Source 300,000 Number of splits that can be processed for a single dataset (table) for Non-FileSystem Sources.
Source 300,000 Combined number of splits that can be processed from all datasets (tables) referenced in a query for both FileSystem Sources & Non-FileSystem Sources after Dremio has pruned partitions for each dataset.
Source 10 MB Maximum size of an Excel file,.xlsx, imported as a data source.
Configuration 25,000 Number of nodes in a query plan.
Workload Management 1000 Total number of executing and queued queries per coordinator node.
Uploads 500MB
10MB
Number of bytes that can be uploaded through the UI.
Maximum size of an Excel file,.xlsx.
Downloads 1M rows Number of rows that can be downloaded through the UI.
Data Type Size 32000 bytes Maximum size in bytes allowed while reading data in varbinary for all source types.
Data Type Size 32000 bytes Maximum size in bytes allowed while reading data in varchar for all source types.