GET_DDL() to ERD diagrams Snowflake tool

user_10177264 0
Viewed 1079

I have been looking for several days to no avail and I just want a tool to create ERD diagrams from the GET_DDL() output in Snowflake. I cannot connect directly to the database for security reasons and the ERD diagrams must be generated from the DDL only. It is completely fine if it cost money, but I cannot find a tool that accomplishes this. Thus far, I have tried:

  • DBeaver (Requires live connections)
  • DBSchema (Poor documentation and keeps throwing errors)
  • SQLdbm (Also, throws unknown error with output)
  • Visual Paradigm
  • DBVisualiser

I would love to use one of the above listed tools if someone knows how to use them OR pay money for a tool that actually works. I'm just looking for any solution to this that is quick and cost less than $200 roughly to use.

snowflake-cloud-data-platform entity-relationship data-modeling
3 Answers

We use ER Studio by Idera for this (https://www.idera.com/er-studio-enterprise-architecture-solutions). Unfortunately is way over your budget at around USD1400 per license.

However, it allows you to create a model by importing the DDL in a .sql file. Initially it did not support Snowflake, and we have to make the DDL Oracle compatible (closest supported DB), but is now supports Snowflake.

user_77957490
user_90410080
user_126758590
Related