Howdy!
In this short and concise blog post, I am really excited to be sharing on how to reverse engineer from ER/Studio via ODBC.
Step 1 –> Under the Snowflake Help Menu, Click on the Download hyperlink.
Next choose ODBC and download the appropriate ODBC Driver.
Configuring ODBC Driver
Once you click next, you will be warned that its not supported.. Ignore the warning and continue.
Once you click Finish, you will see the reverse engineering process begin!
The final Screen showing the Reverse Engineering Process is completed.
Now y’all can see the finished Data Model.
DataType Matching…
For reverse engineering from ODBC check out this article.
http://docwiki.embarcadero.com/ERStudioDA/171/en/Configuring_ODBC_Data_Source_and_Target_Connections
Congratulations! You have just reverse engineered a Snowflake Database in ER/Studio.
Kudos to my good friend and Database SuperHero @Kent Graziano for the initial guidance.
Schedule a demo to see how ER/Studio connects directly to Snowflake via ODBC—turning your cloud warehouse into a fully documented data model in minutes. Book Your Demo Today.
Yes. Using the ODBC driver, ER/Studio can connect to Snowflake and reverse engineer its schema into a visual data model.
You’ll need the Snowflake ODBC driver, valid credentials, and the 64-bit ODBC Data Source Administrator to configure the connection.
Nope! You can safely ignore the warning and proceed—reverse engineering will still complete successfully.
ER/Studio creates a logical and physical data model, complete with tables, columns, data types, and relationships.
You can reference this setup guide in the ER/Studio documentation:
Configuring ODBC Data Source and Target Connections
