Sign in Sign up

Nearly every month you get new benefits

Coming soon
Git integration support for JSON and dbt YAML
Smoother foreign key workflow and handling
Tx Tests
See all release notes
2024
September
Tx Deploy and Run
Tx Deploy and Run

Environments, Deployments, and API to run productive data pipelines

Tx Flows
Tx Flows

Dynamic transformation pipelines for visualization and job execution

Logical data type precision rules
Logical data type precision rules

Now support none, any, and exact precision

August
Tx Macros
Tx Macros

Dynamic and reusable macros in Tx Objects for time-savings and consistency

Reverse Engineer physical projects from Excel
Reverse Engineer physical projects from Excel

Bulk edit project structure and create objects via XLSX

Logical visibility flags
Logical visibility flags

Logical-only/physical-only flags to show/hide objects in projects and view modes

Snowflake case sensitivity
Snowflake case sensitivity

Object and column-level property to respect double-quoted names

July
Logical projects
Logical projects

Subtypes and supertypes support with physical transformation options

Global modeling
Global modeling

Enhancements to object display, handling, and merge behavior

Postgre
Postgre

Partitioning key support for tables

June
Tx
Tx

Support all gits and new functionality

Snowflake direct connect
Snowflake direct connect

Support object filtering

Google external storage
Google external storage

Google Cloud Platform support for Enterprise Plus hosting and security

SQL Server
SQL Server

Direct Connect for Azure Cloud hosting

Postgre enhancements
Postgre enhancements

Views, new data types, and more Errors and Warnings

May
Tx
Tx

Transformational and relational modeling in one project

Logical-only projects
Logical-only projects

With custom data type mapping and conversion options

Data preview
Data preview

Sneak a peek at sample data directly from the diagram

April
Amazon Redshift Direct Connect
Amazon Redshift Direct Connect

Reverse engineer Redshift DDL faster than ever

Table Templates enhancements
Table Templates enhancements

Now available for Databricks and Azure Synapse

Duplicate Diagrams
Duplicate Diagrams

Create copies of project diagrams in one click

March
Global Modeling
Global Modeling

Global reference across projects

dbt sources
dbt sources

Configure and assign sources to project objects

Azure Synapse
Azure Synapse

External tables now supported

Table templates
Table templates

New enhancements and availability for BigQuery

Data governance
Data governance

Data steward tagging

February
Databricks external tables
Databricks external tables

External tables are now fully supported

Databricks default constraints
Databricks default constraints

The latest column constraint released by Databricks

Data types and constraints in dbt YAML
Data types and constraints in dbt YAML

Option to include these in model YAML generation

API. Get dbt YAML
API. Get dbt YAML

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

Views on logical diagrams
Views on logical diagrams

Option to allow views to appear in logical view mode

January
dbt properties
dbt properties

Maintain dbt object and column properties and include them in output YAML... Find out more

Data governance reports in confluence
Data governance reports in confluence

Publish Reports to Confluence with search and navigation. ... Find out more

Status Page
Status Page

Real-time status tracking of SqlDBM Modeling, API, and Schema Monitoring services... Find out more

2023
December
Table templates
Table templates

Table templates - stage, dim, hub - create any kind of table in one click through predefined settings... Find out more

Azure external storage (Enterprise Plus)
Azure external storage (Enterprise Plus)

Azure external storage (Enterprise Plus) - customer-managed storage support for Azure blob... Find out more

Confluence diagram and subject area selection
Confluence diagram and subject area selection

Confluence diagram and subject area selection - option to restrict sharing when embedding projects... Find out more

November
IP access management
IP access management

Allow or restrict access to your data models through admin-managed IP policies... Find out more

Audit logs
Audit logs

Review site access by user and date range for auditing and compliance... Find out more

Visual changelog
Visual changelog

Spot and review trends or off-schedule changes on a visual timeline... Find out more

SSO for direct connection
SSO for direct connection

Direct connect to Snowflake with Azure AD/Entra ID using OAuth... Find out more

October
Data governance. Import/export fields through XLSX
Data governance. Import/export fields through XLSX

Add fields to Excel import/export functionality... Find out more

Google BigQuery. Alter script
Google BigQuery. Alter script

Alter script support for Forward Engineering and Environments.

Performance improvements for large projects
Performance improvements for large projects

Improve loading and compare for large projects.

Open API. Get DDL for specific object
Open API. Get DDL for specific object

Add command to get DDL for a named/individual object... Find out more

September
Data Governance Pages
Data Governance Pages

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

DBT meta fields
DBT meta fields

With this setting, and Data Governance field can be included in dbt's "meta" YAML property. Now, users can synchronize metadata between SqlDBM and dbt projects... Find out more

Easy invite mode for projects
Easy invite mode for projects

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

Locate on diagram
Locate on diagram

Database and Diagram explorer screens now allow users to locate objects on any existing diagram and jump there directly... Find out more

August
Data Governance Reports
Data Governance Reports

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

Views for Google BigQuery
Views for Google BigQuery

Native support for views (including materialized) for GBQ projects... Find out more

July
Google BigQuery
Google BigQuery

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 direct connect via unity catalog API
Databricks direct connect via unity catalog API

Databricks - serverless reverse engineering using Unity Catalog API... Find out more

June
DB Schema monitoring
DB Schema monitoring

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

User groups
User groups

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

May
Data Governance
Data Governance

With the data 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
Snowflake tags

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

April
Databricks alter script
Databricks alter script

Alter scripts for changes in across Databricks projects and environments

March
Enterprise Plus - Security & Compliance Plan
Enterprise Plus - Security & Compliance Plan

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

RELY property for Snowflake constraints
RELY property for Snowflake constraints

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.

Moving relationship lines
Moving relationship lines

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.

February
Dashboard project search
Dashboard project search

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.

Change column order in edit mode
Change column order in edit mode

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.

January
Databricks support
Databricks support

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.

2022
December
Support alter script for Oracle
Support alter script for Oracle

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.

REST API for Enterprise users
REST API for Enterprise users

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.

November
Oracle projects are now fully supported in SqlDBM
Oracle projects are now fully supported in SqlDBM

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.

October
Concurrent working for Enterprise users
Concurrent working for Enterprise users

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

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.