Enterprise ready data modeling

cloud-based and collaborative

Powering modern frameworks and methodologies

Data warehouse & data lake

Latest Snowflake features Support for the latest features like Snowflake’s VARIANT datatype for semistructured data, views, and column lineage allows users to go beyond pure relational modeling. Model and present SqlDBM diagrams are living interactive documents that allow users to present their designs in real-time at any level of detail - from conceptual to physical - and generate the DDL, alters and YAML. Views, functions and procedures In our diagrams, objects such as views and procedures can live alongside physical tables to provide insight into data pipelines and transformations at the heart of a data warehouse.

Data mesh framework

Subject areas Distributed teams can happily share the same database platform and organize themselves across projects using subject areas - keeping their diagrams separate while having global enterprise visibility. Comments and metadata is picked up automatically during the reverse engineering process and can be maintained via Excel by anyone in the organization. Multiple projects and database platforms Zhamak Dehghani first introduced the concept of a data mesh to overcome the ungovernability of data lakes and the bottlenecks of monolithic data warehouses. But distributed data teams can still take advantage of SqlDBM’s one-stop documentation and search across multiple projects and database platforms.

Data vault methodology

A sponsor of the WWDVC SqlDBM is a strong supporter of the data vault community, a sponsor of the WWDVC conference two years running, and the modeling tool of choice during official data vault courses. Hubs, links, satellites SqlDBM’s templates, naming conventions, and logical to physical translations are built to ensure consistency and time savings in repeatable operations such as the creation of hubs, links, satellites, and bridge tables. Colors and view modes Colors and view mode options make it easy for users to find their way around expansive DV architectures and work with them at any level of detail. Automated DV templates and an object creation wizard are currently in the works and will be available soon, along with other exciting enhancements.

Everything you need at your fingertips

Data modeling

By bringing your existing DB/DW to SqlDBM, you can automatically create a database model that will provide powerful and effective visualization. Make changes and generate new SQL scripts including alter scripts.

Direct connection

Securely connect to cloud databases such as Snowflake and Azure Synapse directly from SqlDBM to browse schemas and retrieve DDL automatically.

Lineage analysis

Visualize sources, joins, transformations, and outputs in real-time at column level to understand complex views and DML logic quickly. Syntax to column highlighting in the editor and diagram allows users to track any field as it flows from the sources to final output.

Governance

Comments are read from DDL and available on a single screen where users can find and edit objects across the entire project. Flags help identify sensitive fields and can be used for tracking and filtering at the object or column level.

Collaboration

Work concurrently and comment on any object tagging and alerting specific team members. View modes allow users of any technical level to view, explore, or develop a DB schema without converting the project.

Git and DataOps

Compare project revisions to live DB environments and generate ad-hoc alter scripts between them. Pair your project with any online git repository to automatically push alters or individual objects to new branches and pair with CICD tools like Schemachange or Flyway for fully automated deployments.