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 →

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