DbSchema for Dremio: Visualize the Lakehouse Data Model

Dremio queries S3, ADLS, and Google Cloud Storage where the data lies, through sources, spaces, and virtual datasets. DbSchema introspects those spaces and datasets over JDBC and diagrams the semantic layer — the view of the lakehouse your BI team keeps asking for.

Chart how virtual datasets relate across every underlying storage source
Write SQL with autocomplete for space, dataset, and column names
Page through dataset rows to validate results after a source change
Work with Dremio Software and Dremio Cloud from the same project

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema diagramming Dremio spaces and virtual datasets

Trusted by teams at

Datasets Built on Datasets
Until Nobody Remembers the Bottom

A healthy semantic layer accumulates: virtual datasets refine other virtual datasets, spaces multiply per team, and the S3 Parquet file at the bottom of a lineage chain is four definitions away. The query works — explaining it is the hard part.

DbSchema draws spaces and virtual datasets as one diagram, so the lakehouse data model becomes something you present, not something you reconstruct.

Query, Document & Arrange
the Semantic Layer

Desktop tooling for the layer between raw storage and the dashboards.

Write cross-source SQL against Dremio in the DbSchema editor

Cross-Source SQL With Autocomplete

Compose queries that join a Parquet file on S3 with a relational table, with completion for spaces, datasets, and columns — then export the results to CSV.

Arrange Dremio virtual datasets into focused diagrams

One Layout per Space or Project

Arrange datasets into focused diagrams by space or domain, and export the layouts for architecture sessions where the whiteboard used to be improvised.

Generate HTML documentation for Dremio virtual datasets

A Catalog Supplement You Can Send

Generate HTML or PDF documentation of spaces and virtual datasets — a browsable reference for governed lakehouse environments and new analysts alike.

Dremio Runs the Queries
the Model Keeps the Design

New virtual dataset structures start in DbSchema's offline model — sketched, discussed, and agreed before anything is published to a space.

Sketch Before You Publish

Draft dataset structures on the canvas without touching the running lakehouse.

Version the Semantic Layer

The model is a file — commit it with the pipeline code it belongs to.

Agree as a Team

Pass the model around for review; comments and diffs replace surprise dataset changes.

Publish reviewed dataset designs to Dremio

Publish When Ready

Apply the agreed design to Dremio on your schedule, environment by environment.

Dremio Connection Facts

Register the Dremio JDBC driver JAR (com.dremio.jdbc.Driver) from the Dremio download center in DbSchema's driver manager. Connections use port 31010 and a URL of the form jdbc:dremio:direct=localhost:31010, authenticated with your Dremio username and password; for Dremio Cloud, swap in the cloud endpoint and a personal access token. Reflections keep accelerating queries transparently through JDBC, so DbSchema benefits from them with no extra configuration. Setup details are on the Dremio JDBC driver page.