Query and Diagram Apache Impala Schemas with DbSchema

Impala answers SQL over data on HDFS, Kudu, and S3 with sub-second turnaround. DbSchema is the desktop side of that speed: the metastore tables on an ER diagram, a SQL editor for low-latency queries, and a data explorer for spot checks — no impala-shell required.

Diagram the tables Impala serves from the Hive metastore
Query from a GUI with sortable, scrollable results
Spot-check dashboard tables without writing a SELECT
Reach Kerberos-secured and TLS/SSL clusters

available for

ISO-27001 certified

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

Free Download

DbSchema diagramming Apache Impala tables from the Hive metastore

Trusted by teams at

One Metastore, Three Storage Layers
Kept Straight on One Diagram

The same Impala table names resolve to Kudu, Parquet-backed HDFS storage, or S3, and everyone reasons about them through the shared Hive metastore. Without a visual reference, that reasoning happens in terminal scrollback.

DbSchema pulls the table definitions through Impala's JDBC connection and renders the shared schema as an ER diagram — one picture for the analysts, the engineers, and the pipelines they debug.

See, Query & Spot-Check
Impala at Interactive Speed

Fast answers deserve a client that keeps up with them.

Metastore Tables as an ER Diagram

Databases, tables, and column definitions come straight from the metastore into an interactive diagram — browsable structure instead of DESCRIBE output.

Run low-latency Impala SQL queries from DbSchema

Low-Latency SQL from the Desktop

The editor speaks Impala SQL — Kudu table operations, Parquet format hints, analytic window functions — and shows results in a sortable, scrollable view.

Browse Apache Impala table data interactively in DbSchema

Data Quality at a Glance

Paginate through the tables behind your BI dashboards, filter by column, and confirm what a pipeline actually delivered — all without typing SQL.

The Schema Behind the Dashboards
Published Where Everyone Reads It

Analysts, report builders, and pipeline consumers keep asking what a column means and where a table came from. Generate interactive HTML5 documentation of the Impala schema — searchable, commented, and served from a link instead of from your calendar.

Explore the Documentation Tool

Interactive HTML5 documentation of an Apache Impala schema

Impala Cluster Connection Facts

Impala listens for JDBC clients on port 21050 by default, giving the standard URL jdbc:impala://host:21050/default. Get the Cloudera Impala JDBC driver (ImpalaJDBC42.jar) from the Cloudera download portal and add it in DbSchema's driver manager — the Impala JDBC driver page walks through the setup.

For Kerberos, append ;AuthMech=1;KrbRealm=REALM;KrbHostFQDN=host;KrbServiceName=impala to the URL; for a TLS/SSL-secured cluster, add ;SSL=1;SSLTrustStore=/path/to/keystore instead.