Nearly every month you get new benefits
Push dbt source & model YAML to git in Forward Engineering
Added support for multiple repos in push-to-git
Simplified UI for Foreign Keys and Relationships
Embed SqlDBM diagrams in on-prem hosted Confluence
Data vault automation in a single click with customizable Tx Templates
Manage DB credentials and (multiple) git integration at user level
Reverse engineering for large projects is now exponentially faster
Concurrent working, Excel import, compare revisions
Better suggestions with strict mode
Trigger Tx Flows and obtain run logs
Control for case sensitivity and new template capabilities
Environments, Deployments, and API to run productive data pipelines
Dynamic transformation pipelines for visualization and job execution
Now support none, any, and exact precision
Dynamic and reusable macros in Tx Objects for time-savings and consistency
Bulk edit project structure and create objects via XLSX
Logical-only/physical-only flags to show/hide objects in projects and view modes
Object and column-level property to respect double-quoted names
Subtypes and supertypes support with physical transformation options
Enhancements to object display, handling, and merge behavior
Partitioning key support for tables
Support all gits and new functionality
Support object filtering
Google Cloud Platform support for Enterprise Plus hosting and security
Direct Connect for Azure Cloud hosting
Views, new data types, and more Errors and Warnings
Transformational and relational modeling in one project
With custom data type mapping and conversion options
Sneak a peek at sample data directly from the diagram
Reverse engineer Redshift DDL faster than ever
Now available for Databricks and Azure Synapse
Create copies of project diagrams in one click
Global reference across projects
Configure and assign sources to project objects
External tables now supported
New enhancements and availability for BigQuery
Data steward tagging
External tables are now fully supported
The latest column constraint released by Databricks
Option to include these in model YAML generation
Option to allow views to appear in logical view mode
Maintain dbt object and column properties and include them in output YAML... Find out more
Publish Reports to Confluence with search and navigation. ... Find out more
Real-time status tracking of SqlDBM Modeling, API, and Schema Monitoring services... Find out more
Table templates - stage, dim, hub - create any kind of table in one click through predefined settings... Find out more
Azure external storage (Enterprise Plus) - customer-managed storage support for Azure blob... Find out more
Confluence diagram and subject area selection - option to restrict sharing when embedding projects... Find out more
Allow or restrict access to your data models through admin-managed IP policies... Find out more
Spot and review trends or off-schedule changes on a visual timeline... Find out more
Direct connect to Snowflake with Azure AD/Entra ID using OAuth... Find out more
Add fields to Excel import/export functionality... Find out more
Alter script support for Forward Engineering and Environments.
Improve loading and compare for large projects.
Add command to get DDL for a named/individual object... Find out more
Extend documentation beyond the object level with rich text full-length content, embedded images, diagrams, styling, and formatting. Pages allow teams to maintain project-level overviews of things like metrics and KPI definitions, business terms, and operational outlines... Find out more
With this setting, and Model Governance field can be included in dbt's "meta" YAML property. Now, users can synchronize metadata between SqlDBM and dbt projects... Find out more
Enterprise plan projects now include a setting to enable anyone on the project team to invite more collaborators - taking the burden off the project owner... Find out more
Database and Diagram explorer screens now allow users to locate objects on any existing diagram and jump there directly... Find out more
An all-in-one project information portal in HTML format for end-users with searchable object details, descriptions, and references. Reports offer a sleek interface for finding and navigating between related project assets... Find out more
Native support for views (including materialized) for GBQ projects... Find out more
SqlDBM is thrilled to announce Google BigQuery as the latest cloud data platform to be supported as a native project type. Out of the gate, SqlDBM users will be able to direct connect to their BigQuery projects and begin modeling and maintaining their database objects and metadata... Find out more
Databricks - serverless reverse engineering using Unity Catalog API... Find out more
Undetected object changes can have unintended consequences in downstream data pipelines. SqlDBM’s Snowflake Schema Monitoring periodically polls your Snowflake databases and alerts designated recipients if DDL changes are detected-giving you the opportunity to be take proactive measures. Our dedicated dashboard lets administer monitoring job runs and review the logs and changes detected on past and a visual timeline to spot change patterns... Find out more
Large teams on SqlDBM Enterprise plans can now create and manage user groups. User groups can then be added to projects just like individual collaborators, giving access to everyone in the group. User groups make it easier than ever to collaborate across multiple teams and quickly bring (or remove) multiple users into a project in a single step... Find out more
With the model governance suite, SqlDBM steps into the cataloging and metadata management arena. For organizations looking for a streamlined governance solution without going all-in on a dedicated cataloging tool, SqlDBM brings user-defined fields to the database documentation. Find out more
Snowflake tags are now fully supported across all of SqlDBM, including reverse and forward engineering and alter scripts. You can now manage and apply tags to all supported project objects and validate and deploy tagged assets to your database. Find out more
Alter scripts for changes in across Databricks projects and environments
With Enterprise Plus, customers get all the modeling and collaboration features available in SqlDBM, plus robust, enterprise-grade security. This plan offers features like customer-managed S3 hosting and encryption keys, AWS Private Link, IP management, and access logs. Find out more
Snowflake constraints (PK, FK, AK) support RELY in reverse/forward engineering and object properties. The RELY property is a keyword included in the constraint definition and acts as a hint for the Snowflake optimizer to rely on the integrity of the constraint and perform join elimination on views and redundant queries. An article describing how RELY can improve query cost and performance is available here.
By popular demand, relationship lines are now customizable in SqlDBM diagrams. Users can bend relationship lines at any point and set their shape permanently on the diagram. This functionality provides complete control over diagram design and ensures that relationships are properly situated for clearer separation and understanding.
Our latest release adds search functionality to the project dashboard. SqlDBM users can now find the project they are looking for faster by typing all or part of the name into the search bar at the top of the page. Search results include personal and shared projects as well as branch names from those with concurrent working.
SqlDBM's visual modeling interface lets users rearrange or clone columns in or across tables by simply clicking and dragging. Now, the same functionality is also available in the single-table edit mode. Using the handles to the left of a column, users can drag to rearrange column order or ctrl+drag to clone existing columns while editing a table.
SqlDBM is excited to partner with Databricks and provide native support for Databricks projects-offering collaboration, visibility, and cataloging, all in the cloud. Databricks provides the management and performance of a data warehouse with the flexible object store of a data lake.
Oracle projects were released in open Beta last month and enhancements are already rolling out. Alter scripts for Oracle projects are now available in our latest release. Be on the lookout for additional improvements like views support and conversion to other project types, as we work diligently to bring Oracle projects out of Beta and into full support.
A secure API for programmatically accessing SqlDBM projects is finally here-opening the door to unlimited integration potential. We've also been hard at work enhancing the recently-released Oracle project feature, which now supports alter scripts.
Oracle, the world's biggest database platform by market share, is now available in SqlDBM as a supported project type. Enjoy familiar features like reverse and forward engineering, atler scripts, and revision compare with Oracle-native syntax and properties.
The entire project team can now work collaboratively and in parallel without having to lock a project. Changes made in any branch can be compared before merging to main and synchronized with any new updates that happen meanwhile. It's everything you've come to appreciate with git, built right into SqlDBM.
AlloyDB is a PostgreSQL-compatible database service for demanding enterprise database workloads that combines the best of Google Cloud Platform with one of the most popular open-source database engines. AlloyDB is more than 4X faster than standard PostgreSQL for transactional workloads and 100X faster for analytical queries.