On this page

    Limits

    This topic lists the Dremio limits.

    TypeLimitDescription
    Catalog32kSize of fields in records.
    Catalog800Number of columns in tables.
    Source60,000Enables 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+.
    Source300,000Number of splits that can be processed for a single dataset (table) for Non-FileSystem Sources.
    Source300,000Combined 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.
    Source10 MBMaximum size of an Excel file,.xlsx, imported as a data source.
    Configuration25,000Number of nodes in a query plan.
    Workload Management1000Total number of executing and queued queries per coordinator node.
    Uploads500MB
    10MB
    Number of bytes that can be uploaded through the UI.
    Maximum size of an Excel file,.xlsx.
    Downloads1M rowsNumber of rows that can be downloaded through the UI.
    Data Type Size32000 bytesMaximum size in bytes allowed while reading data in varbinary for all source types.
    Data Type Size32000 bytesMaximum size in bytes allowed while reading data in varchar for all source types.