Nearly every month you get new benefits

Views and Materialized views are now available in the Database Documentation screen

Global objects shared across projects can now be referenced using physical relationships

Case settings now support separate rules for logical and physical

The multi-select feature allows you to quickly add multiple objects from the explorer to your diagram

iFrame embeds for projects in third-party systems

Snowflake views on the diagram with editable columns and parameters

Enhanced foreign key linking experience

Snowflake revamped object parser offers faster performance

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

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

Now support none, any, and exact precision

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 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

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

Obtain dbt-compatible Source and Model YAML for project objects...Find out more

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

Review site access by user and date range for auditing and compliance...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.