Dremio Cloud
Dremio Software
 
On this page

    Limits

    This topic lists the Dremio limits.

    Type Limit Description
    Catalog 32k Size of fields in records.
    Catalog 6400 Number of leaf columns in tables. See Creating and Querying Wide Tables for details.
    Catalog 800 Number of leaf columns in a table that a query can scan. See Creating and Querying Wide Tables for details.
    Source 60,000 Enables unlimited splits for FileSystem sources. dremio.iceberg.enabled must also be enabled. This support key is available using Dremio v18.0+, but is enabled by default with Dremio v21.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.