A map for your whole Snowflake account

Snowflake Schema Design and Data Modeling with DbSchema

Snowflake spreads data across accounts, databases, schemas, and tables. DbSchema pulls that hierarchy into one visual model: diagrams your engineers navigate, documentation your analysts read, and schema changes you review as DDL before they run.

  • Reverse engineer databases, schemas, and tables into diagrams you can arrange by domain
  • Publish HTML documentation analysts open in a browser — no warehouse access needed
  • Compare development, staging, and production schemas to catch drift
  • The Snowflake JDBC driver downloads automatically on first connect
available for ISO-27001 certified ISO-27001 certified
Free Community Edition No signup required 15-day Architect trial included
Free Download
DbSchema modeling a Snowflake warehouse with ER diagrams and schema documentation
100+ Databases
|See All   >

Trusted by teams at

Everyone Queries the Warehouse
Few Can Picture It

A busy warehouse accumulates databases, schemas, and tables faster than anyone documents them. Analysts guess what a column means, engineers answer the same question again in chat, and the real reference is whoever built the pipeline.

DbSchema gives the account one visible model — relationships traced across schemas and databases, documentation data consumers can read, changes reviewed before they run — without bouncing between worksheets.

Model, Document & Review
the Warehouse in One Place

From the first reverse-engineered diagram to reviewed DDL, one tool carries the whole workflow.

Reverse engineer Snowflake schemas into ER diagrams
Chart a Warehouse You Inherited

Connect once and DbSchema lays out databases, schemas, tables, and views as diagrams — orientation in minutes for every engineer who joins the data team.

Generate HTML documentation for a Snowflake warehouse
Give Data Consumers a Readable Reference

Export HTML documentation with embedded diagrams, table definitions, and column descriptions — one self-contained reference for people without direct warehouse access.

Compare Snowflake schemas across environments
Catch Drift Between Environments

Compare two Snowflake environments, or a live schema against the model, review each difference, and generate the DDL that closes the gap.

Build Snowflake queries with the visual query builder
Build the Query by Clicking

Assemble SELECT statements from tables, joins, and filters in the visual builder; the generated SQL runs on your warehouse and lands in the results grid.

Browse Snowflake table data in the data explorer
Audit Rows After Every Pipeline Run

Browse table contents, filter by column, and page through large result sets without writing a query — quick verification that a transformation did what it should.

Write Snowflake SQL in the DbSchema editor
Write SQL That Knows Your Schema

An editor with autocomplete for your tables and views, script execution, and results you can edit inline or export to CSV, Excel, or JSON.

Plan warehouse changes without sharing live data.

Worksheets Show What Ran
The Model Shows the Design

Your warehouse design lives in a model file on your machine, not only in the account. That separation lets you draft offline, review like code, and choose what reaches Snowflake.

Draft the Snowflake schema offline
Draft Offline

Work on the schema in a meeting or on a flight — connect later to apply it.

Track the Snowflake model in Git
Put the Warehouse in Git

Branch and pull-request the model with the rest of your data project.

Review generated Snowflake DDL
DDL Before Deployment

Read the exact statements a change produces before your warehouse sees them.

Promote Snowflake changes across environments
Promote With Intent

Walk one reviewed change through development, staging, and production.

Warehouse Changes,
Reviewed Like Application Code

Commit the model, open a pull request, and the team sees exactly which tables and columns change. After approval, DbSchema translates the visual diff into DDL and walks it into the environment you choose.

Snowflake schema synchronization between the Git model and warehouse environments
Read Git Workflow Docs

One Link Answers
"What Does This Table Mean?"

Interactive HTML5 documentation with zoomable diagrams, column comments, and hover details opens in any browser. Analysts and stakeholders read the warehouse structure with nothing installed and no account login.

Explore the Documentation Tool

Interactive HTML5 documentation generated from a Snowflake schema

AI Assistant for Your Warehouse Model

Ask for a query in plain English, or paste one and ask what it does. Because the Assistant reads your design model, the answers name your schemas and tables, not invented examples.

See What the AI Assistant Can Do

DbSchema AI assistant generating SQL for a Snowflake model

Watch: Snowflake Diagrams
From First Connection to Canvas

Designing Snowflake ER diagrams and connecting DbSchema (3 min). DbSchema downloads the Snowflake JDBC driver automatically on first connection. The URL follows jdbc:snowflake://account.snowflakecomputing.com/, with db, schema, warehouse, and role set in the connection properties; for production, supply a privateKey in the advanced properties to authenticate with a key pair instead of a password.

Give Your Warehouse a Map

No signup — the free Community Edition and the 15-day Architect trial ship together.

Download Free

Tutorials and guides

Frequently asked questions

Use the Snowflake JDBC driver with account, warehouse, database, and role parameters. DbSchema guides you through driver setup on first connect.

Yes. Supply a privateKey value in the advanced connection properties instead of a password — useful for production environments where plain-text credentials are not acceptable.

Yes. Publish HTML documentation from your Snowflake model for analytics and engineering teams.

Yes. The Community edition is free and covers reverse engineering, diagrams, and the SQL editor; Pro features such as schema sync and HTML documentation include a 15-day trial.

Yes. Visual changes can be translated into reviewed SQL scripts before you run them in Snowflake.

Teams working with Snowflake often use these engines too. Explore dedicated guides and JDBC setup for each.

Browse all 100+ supported databases