---
title: "STACKIT Dremio"
description: "Open Data Lakehouse engine enabling sub-second SQL queries directly on cloud storage without complex ETL pipelines."
scfAsset:
  category: "service"
  managed: true
  marketplaceUrl: "https://marketplace.stackit.cloud/en/products"
  tags: ["Data Lakehouse", "Dremio", "SQL", "Analytics", "Data and AI"]
  maintainers:
    - user: "alexander.gabert"
source_url: "https://framework.stackit.cloud/data-and-ai/assetcontainer/stackit/stackit-service-dremio/"
source_file: "docs/data-and-ai/assetcontainer/stackit/stackit-service-dremio.mdx"
---

STACKIT Dremio is a managed Data Lakehouse engine that provides high-speed SQL analytics directly on cloud object storage using Apache Arrow technology.

## Service Overview
- **ETL-Free Virtualization**: Eliminates time-consuming data copies by querying underlying data sources in place.
- **Sub-Second Analytics**: Accelerates slow BI dashboards using advanced Data Reflections™ acceleration technology.
- **Unified Semantic Layer**: Delivers a consistent, governed catalog view across diverse enterprise data sources.

## Technical Details
- **Performance Engine**: Built on Apache Arrow for fast columnar in-memory query processing.
- **Governance**: Granular column- and row-level access security policies integrated with STACKIT IAM.
- **BI Connectivity**: Native connectors for BI tools including Tableau, PowerBI, and standard JDBC/ODBC clients.

## Engine Sizes

The values below come from the STACKIT documentation and update themselves.

> From the STACKIT docs: [Compute resources for Dremio › Available engines for STACKIT Dremio](https://docs.stackit.cloud/products/data-and-ai/dremio/basics/compute-resources/#available-engines-for-stackit-dremio) (Source updated 18.08.2026, copied 05.10.2026)

On creation or editing, you can choose CPU and memory of your Dremio engine. Due to a limitation in Dremio, the UI doesn’t reveal the real allocation of vCPUs configured for that size. To mitigate the possibility of creating an invalid configuration, only the `28C`-CPU-option is exposed in the UI. You define the real CPU count with the configuration of the size:

| Size | CPU (UI) | vCPUs (applied) | Memory (GiB) | Instance Count | Availability |
| --- | --- | --- | --- | --- | --- |
| STACKIT 2XS | 28C | 7 | 28 | 1 |  |
| STACKIT XS | 28C | 14 | 56 | 1 |  |
| STACKIT S | 28C | 28 | 112 | 1 | with General Availability |
| STACKIT M | 28C | 28 | 112 | 2 | with General Availability |
| STACKIT L | 28C | 28 | 112 | 4 | with General Availability |

CPU or memory combinations that aren’t listed will be discontinued on August 26, 2026. This means that existing engines of those combinations won’t start and that you can not order new engines of that type.

If you have issues migrating to new engines, check our [Dremio FAQ](https://docs.stackit.cloud/products/data-and-ai/dremio/faq/).

## Limitations & Constraints
- **Reflections Storage Cost**: Data Reflections generate physical acceleration indexes that consume additional Object Storage.
- **Metadata Sync Delays**: Source metadata updates follow scheduled polling intervals (typically 15 to 60 minutes).
- **UI Upload Capping**: Direct file uploads through the Dremio user interface are capped at 50 MB per file.

<LinkCard title="STACKIT Dremio Overview" href="https://docs.stackit.cloud" />