SqlDBM partnership with Snowflake
At SqlDBM, one of our core beliefs that we really strive to infuse into everything we do, is to truly listen to our users’ requests and feedback. A significant percentage of our users expressed that they would want the ability to design Snowflake DW using SqlDBM. We listened and actualized that.
After almost two years on the market, SqlDBM is proud to announce that it is releasing Snowflake Data Modeling support. Now the users of Snowflake DW will be able to seamlessly create data models in SqlDBM and then generate Snowflake DDLs – all this can be done online and in collaboration with other team members.
With this fantastic addition, you can significantly maximize productivity across your company’s Analytical domains, as you design and visualize Snowflake DW in SqlDBM that enables its users with highly intuitive and exceptionally beautiful UI. And of course, you can take advantage of and adapt SqlDBM features into your Snowflake projects such as Dark/Light Theme, Subject Areas, Relationships, Diagrams, View Modes, Revision history , Team Collaboration etc. Team Collaboration feature of SqlDBM is especially important for Snowflake users due to the fact that many companies migrating from Legacy Data Warehouses to Snowflake, and therefore, having a collaborative Data Modeling environment with internal team members and/or external consultants significantly increases migration project deliverability, accessibility and transparency.
Snowflake Support in SqlDBM has plenty of great features, and some of the important ones are listed below:
Support for most popular menu options
- Undo/Redo and Zoom
- Subject Areas and Diagrams
- Add New Table, Relationship, Note
- Change View Mode: Table Names Only, All Columns , Only PK/FK Columns etc.
Support for access to Transient, Data Retention , File Format , Copy Options and other table options
- User has the ability to create common “File Format” and apply to multiple tables
- Also “File Format” has an option to generate “SQL independently as File format” or “be part of table definition”
Generate Snowflake DDLs / Forward Engineer support
User can design Snowflake DW and easily materialize their beautiful designs into valuable SQL script. Forward Engineer feature has various options:
– Create / Drop Schema
– Create / Drop File Format
– Create / Drop Table
Please check out Snowflake with SqlDBM at https://sqldbm.com, let us know how we can improve SqlDBM to resolve your current issues related to Snowflake DW designing/modeling. Help us get the next update to SqlDBM in the best possible shape. Your feedback is important to securing a solid update release, and we greatly appreciate your assistance.