Zeema
New design
Catalogue / data-warehouse

Dremio

Data warehousedremio

Lakehouse platform querying Iceberg and other sources in place, with full SQL DML on Iceberg tables.

Provider
default
Kind
Data warehouse
Category
Data
Official docs
https://docs.dremio.com/current/reference/sql/commands/apache-iceberg-tables/
Properties · 4 set by this component
propertytypevaluesrequiredkind defaultthis component
edition · component propertyenumcommunity | enterprise | cloudnocommunityinherited
formatenumcolumnar | rownocolumnar▸ columnar
managedboolean—nofalse▸ false
realtimeboolean—nofalse▸ false
storesData · component propertyboolean—nofalseinherited
tableFormat · component propertyenumiceberg | deltanoiceberginherited
upsertboolean—nofalse▸ true
Rules that apply · 0

Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.

No rule reads this kind yet. That is a gap, not a guarantee.
Use it in a design
nodes:
  - { id: "dremio", component: "dremio" }
Other Data warehouse products · 39
AnalyticDBalibaba-analyticdbalibabaclouddata-warehouseApsaraDB for ClickHousealibaba-clickhousealibabaclouddata-warehouseHologresalibaba-hologresalibabaclouddata-warehouseMaxComputealibaba-maxcomputealibabaclouddata-warehouseApsaraDB for SelectDBalibaba-selectdbalibabaclouddata-warehouseAmazon Athenaaws-athenaawsdata-warehouseAmazon Redshiftredshiftawsdata-warehouseAzure Analysis Servicesazure-analysis-servicesazuredata-warehouseMicrosoft Fabricazure-fabricazuredata-warehouseAzure Synapse Analyticsazure-synapseazuredata-warehouseR2 SQLcloudflare-r2-sqlcloudflaredata-warehouseClickHouseclickhousedata-warehouseGeneric data warehousedata-warehousedata-warehouseDatabricks SQLdatabricks-sqldata-warehouseApache Dorisdorisdata-warehouseApache Drilldrilldata-warehouseApache Druiddruiddata-warehouseDuckDBduckdbdata-warehouseExasolexasoldata-warehouseFireboltfireboltdata-warehouseGreenplumgreenplumdata-warehouseApache Hivehivedata-warehouseApache Impalaimpaladata-warehouseApache Kylinkylindata-warehouseMonetDBmonetdbdata-warehouseMotherDuckmotherduckdata-warehouseApache Pinotpinotdata-warehousePrestoprestodata-warehouseSnowflakesnowflakedata-warehouseStarRocksstarrocksdata-warehouseTeradata Vantageteradatadata-warehouseTrinotrinodata-warehouseVerticaverticadata-warehouseGoogle BigQuerybigquerygcpdata-warehouseDb2 Warehouse as a Serviceibm-db2-warehouseibmdata-warehouseNetezza Performance Server as a Serviceibm-netezzaibmdata-warehouseIBM watsonx.dataibm-watsonx-dataibmdata-warehouseAutonomous AI Lakehouseoci-autonomous-data-warehouseocidata-warehouseMySQL HeatWave clusteroci-mysql-heatwave-clusterocidata-warehouse
Source
# yaml-language-server: $schema=../../schema/component.schema.json
# Dremio: lakehouse platform querying data in its sources instead of storing it. "Get started":
# Dremio Cloud is the hosted edition and Dremio Software the self-managed one, with a Community
# Edition container for a single node. "Apache Iceberg tables": INSERT, UPDATE, DELETE and MERGE.
schemaVersion: "1"
type: "component"
id: "dremio"
kind: "data-warehouse"
provider: "default"
docs: "https://docs.dremio.com/current/reference/sql/commands/apache-iceberg-tables/"
defaults:
  realtime: false
  upsert: true
  format: "columnar"
  managed: false
properties:
  edition:
    type: "enum"
    values: ["community", "enterprise", "cloud"]
    default: "community"
  tableFormat:
    type: "enum"
    values: ["iceberg", "delta"]
    default: "iceberg"
  storesData:
    type: "boolean"
    default: false

The same page as markdown, for an agent: /catalogue/components/dremio.md