Accelerating cloud migration to Snowflake with SqlDBM

As cloud data warehouses improve the speed and agility of working with data, the surrounding tech stack and business processes must evolve to keep pace. SqlDBM does this two-fold: by being quick to implement and support the new features being released by cloud providers such as Snowflake on the back-end, and by keeping its front-end intuitive and accessible to all types of users — enabling sharing, collaboration, and tracking.

Rich Hathaway, Senior Director of Data Architecture at Intricity, is keenly aware of how this helps speed projects along, especially when working with a mix of internal and external roles. “Other tools are very costly, difficult to work with. On smaller projects, the learning curve can’t keep up. [SqlDBM] is easy to learn, use, and share.”

Rich feels comfortable involving his clients in a project through SqlDBM. Project managers can track progress through compare revisions. Data Architects can set and review naming conventions. Business users can contribute to the project through functional descriptions and documentation. None of this requires any prior experience with SqlDBM.

When changes happen on the database outside of SqlDBM, Rich insists on synchronizing the project through reverse engineering — the operation is instant, ensuring that everything is reflected in one single source. The diagrams stay current, table relationships are maintained, and DDL comments are synchronized to the data dictionary. This way, upon delivering the technical part of the project, the functional side is seamlessly taken care of, with no technical debt remaining.