CODEWITHSUNDEEP
sqldata-modelingsnowflake-cloud-data-platformwarehouse
marcin2x4
marcin2x4

Reputation: 1429

ER modelling tool for Snowflake

From snowflake documentation it seems that there is an ER application that will allow connecting to the dwh to create diagrams - https://www.snowflake.com/blog/support-multiple-data-modeling-approaches-with-snowflake/.

Does anyone know what tool is used in the article? Can you recommend alternative ER tool for modelling purposes?

Upvotes: 0

Views: 1833

Answers (3)

Diego M
Diego M

Reputation: 1

A tool that I developed: https://www.dev4snow.com/

You can do that and much more with it -it's also an IDE.

Diego.

Upvotes: 0

marcin2x4
marcin2x4

Reputation: 1429

Another tool with CI/CD tools I came accross:

https://sqldbm.com/Home/

Upvotes: 0

Hans Henrik Eriksen
Hans Henrik Eriksen

Reputation: 2860

I will assume that there are several tools that will connect to Snowflake and allow you to edit models of its schemas.

The tool used in the article looks like Oracle SQL Developer Data Modeler.
Look at the Wikipedia chart: Comparison of data modeling tools for alternatives.

Also please remember that constraints in Snowflake (references, indices) are soft - not enforced - but that doesn't matter and works fine with Entity Relationship Modeling.

Upvotes: 2

Related Questions