Snowflake to ER Diagram

How it works

1. Get the DDL with SELECT GET_DDL('TABLE', 'your_table') in a worksheet, or copy your CREATE TABLE statements.
2. Paste it into the editor — Snowflake SQL parses, including CREATE OR REPLACE and TRANSIENT tables.
3. Tables render with types like VARIANT, NUMBER and TIMESTAMP_NTZ; foreign keys become relations.
4. Arrange, hide tables, then export PNG/SVG or convert to Mermaid/DBML.

Example

A Snowflake schema like this:

CREATE OR REPLACE TABLE customers (
  id NUMBER(38,0) PRIMARY KEY,
  email VARCHAR NOT NULL,
  profile VARIANT
);

CREATE TABLE orders (
  id NUMBER(38,0) PRIMARY KEY,
  customer_id NUMBER(38,0) REFERENCES customers(id)
);

…renders two tables with a relation from orders.customer_id → customers.id. Try it with your own →

Guide

Warehouse DDL has its own shape and this page speaks it. The canonical way to get Snowflake DDL: SELECT GET_DDL('TABLE', 'customers'); in a worksheet — or for a whole schema, SELECT GET_DDL('SCHEMA', 'analytics');. Paste the output; CREATE OR REPLACE TABLE, CREATE TRANSIENT TABLE, cluster-by clauses and COMMENT = '…' strings all parse or get skipped cleanly.

Snowflake types on the diagram

• Semi-structured columns — VARIANT, OBJECT, ARRAY — render as-is so you can spot where the JSON lives.
• NUMBER(38,0) defaults, TIMESTAMP_NTZ / _LTZ / _TZ, and BOOLEAN.
• Foreign keys are usually only declared in the INFORMATION_SCHEMA if your ELT tool wrote them — if the diagram shows no edges, the constraints genuinely don't exist; use Infer links for convention-based ones.

This is popular with analytics teams documenting dbt sources: paste the raw source tables, export SVG, and drop it next to the dbt docs. Since the paste never leaves the browser, production warehouse DDL is safe to run through it.

Why use it

• Private: everything runs in your browser — nothing is uploaded or stored on a server.
• Interactive: drag tables, auto-arrange, hide noise, add notes, and manually link columns.
• Export a high-res PNG, vector SVG, or the schema as Mermaid / DBML / PlantUML code.
• Snowflake-aware — CREATE OR REPLACE, TRANSIENT tables and VARIANT all parse.
• Free & open source — no account, no sign-up.

FAQ

How do I diagram a Snowflake schema?

Run SELECT GET_DDL('TABLE', 'your_table') (or script several tables) and paste the DDL here. CREATE OR REPLACE TABLE and foreign keys are handled.

Is my schema uploaded anywhere?

No. Everything runs locally in your browser — your schema is never uploaded to or stored on any server.

Can I export the diagram?

Yes — export a high-resolution PNG or vector SVG, copy the schema as Mermaid, DBML or PlantUML, or share a link that encodes the whole diagram in the URL.

Is it free?

Yes. It is completely free and open source, with no account or sign-up required.

Related