This release delivers a revamped Snowflake parser that delivers faster performance and allows for quicker extension for adding new object types in future releases. We've also included fixes from model governance to Reverse Engineering.

Don't forget about our new and improved push to git integration through User Connections, delivered as part of the last release. Please configure User Connections to continue using push to git functionality. More info here.

Changes with no impact on existing DDL/API functions

Relational Modeling

• Snowflake. Parser performance improvements
• Merge FK with relationships UI enhancements (alter script adjustments)
• Governance. Add confirmation popup to field deletion
• Make PE menu items same color
• Reverse Engineering 500 error uploading DLL due to schema in the index
• Errors and warnings list lag for big projects fix
• BigQuery. Fix reserved words wrapped in `` are not correctly parsed
• Scroll wheel zoom sensitivity adjustment
• Snowflake. Simplify “Analize all views”
• Diagram. Highlight PK\FK references and relevant columns
• Fix. Column color inheritance in concurrent working

Push to git enhancements with multi-repo support and new push (dbt) YAML functionality. Foreign Keys and Relationships are merging on the UI for a more intuitive user experience (no impact on existing projects). More info on FK and relationships merge here.

Please configure User Connections to continue using push to git functionality. More info here.

Changes with no impact on existing DDL/API functions

Relational Modeling

• Logical project. Change terminology - Entities and Attributes

• Merge FK and relationships

• Git Integration - Push dbt YAML

• Git Integration - multiple git support in FE

• UI/UX improvements | 24.12.1

• Patch missing CSP directives

• Patch vulnerability: Host header injection on password reset link

• Fix: Snowflake. Reverse Engineer. Compare process is case sensitive marking updates when the only difference is a lower or uppercase letter

• Fix: Model Governance. User can not remove selected values for dropdown types.

• Fix: Tx Error - Failed to execute ‘setItem’ on ‘Storage’ - Setting the value of ‘pid_DM/TX’ exceeded the quota

• Fix: User Groups. User Group is not added to the project

Git repository integrations are moving from Admin to user-level with User Connections. Configure User Connections on the Dashboard/Account settings and use them for fast personal access to database credentials for Direct Connect and push to git on Forward Engineering. Multiple git repositories per connection are supported for users with separate repositories for relational models, dbt projects, and additional use cases.

Please migrate your admin-level git configurations to personal User Connections to avoid disruption to push to git functionality.

Changes with no impact on existing DDL/API functions

Relational Modeling

• Extend User Connections with SSO options

• User Connections. Multiple repo links

• Logical project. Add diagram when importing from Excel

• Table edit mode. Choose the first datatype by enter

• UI/UX improvements

• Extend User Connections with SSO options

• User Connections. Multiple repo links

• Confluence. Remove project size limit restriction

• Confluence. Remove token expiry limit

• reverse engineering performance improvement

Fixes and enhancements

• forward engineering use relationship instead FK index in alter script

• Flags showing twice in Database Documentation

• Flags being deleted when the user defines a relationship between 2 tables

• Admin Account. Unable to invite user to subscription

• Handle high volume of log warnings

• Tool. The user is allowed to duplicate column names, forcing an invalid state in the project

Concurrent working is now available for logical projects. Suggested relationships are now more precise with Strict Mode—where suggestions only consider original parent dimensions (whose PK is not also an FK). Click the heading to see the full list 👆

Relational modeling

• Logical move differentiator informational
• Logical Project. Discriminators. DB Documentation. Export/import xlsx
• Logical Project. Enable concurrent working
• Logical Project. Compare revisions
• Logical project. Update many-to-many
• Import XLSX. Logical project
• Improve zoom sensitivity
• UI/UX improvements | 24.10.1
• Suggested relationships add strict mode option
• Revision Save allows whitespace object names
• Integrations. Git Integration. Repository folders cannot be customized
• Databricks. Special characters are marked as error
• Admin Account. Unable to invite user to subscription
• Order of records for group/permissions affecting collaboration
• Import XLSX. External Storage enablement
• Transfer Project. Transfer of project ownership fails with silent 500 error
• API. The user gets 500 if the resource belongs to another user
• After merging: the diagram is not correctly moved to a Subject Area if this was added to the main branch in current version
• Logical Project. The user cannot FE an exported logical project
• FE. Snowflake RELY constraint option partially applied
• Unable to Export DB to Documentation to XLSX because of special characters

This release brings logical data type precision control and many improvements to the Excel reverse engineering process. Click the heading to see the full list 👆

Changes with no impact on existing DDL/API functions

Data Modeling

• Enable User Connections and Pendo popup
• Long running ValidateMergeLiveRevision requests
• Admin. Cant grant edit permission for CW user update-role 500 (Internal Server Error)
• Compare. Overloaded procedure names appear as changes
• Import XLSX. User can create two PK/FK for same columns
• Import XLSX. Warning about duplicated tag object is not displaying
• Import XLSX. Incorrect error message after importing of XLSX with missing sheet
• Import XLSX. Error for model with column template. The given key was not present in the dictionary
• Import XLSX. Table objects are displaying as updated without changes made
• Import XLSX. Unique Keys AK are being removed after importing XLSX
• Import XLSX. Tags sheet is presented for projects without tags
• Import XLSX. PK are being removed after importing XLSX on top
• Import XLSX. Error appears after importing XLSX on top for PostgreSql
• Logical Project. Precisions
• Logical Project. The precision is lost when the user imports elements from a Physical project
• Logical Project. The precision is lost when the user exports from Logical Project to Physical projects and the type is not mapped
• WRONGTYPE Operation against a key holding the wrong kind of value
• Concurrent Working. Merge performance improvements

New in this release: relational project Reverse Engineering from Excel. Also note the enhancements to Logical projects such as selective import and logical-only/physical-only flag. Click the heading to see the full list 👆

Changes with no impact on existing DDL/API functions

Data Modeling

• Import / Export XLSX.

• Snowflake. Case Sensitivity

• Rename ‘locate on diagram’ and other text/UI

• Alter script shows no changes after adding auto-increment IDENTITY to existing PK

• Remove SqlDBM Products popup

• Dashboard. Concurrent Working. Add label for branch view only if it’s read only

• Add a hyphen in Project level objects

• Make Settings and conventions the last item in all projects menu order

• User groups. No Rate Limit On Inviting / Adding Team

• Tool. Naming Conventions. User can export fields which characters are prohibited by security

• Apply glossary rules to physical names

• Copy Project. Data Governance is not copied to other projects when External Storage is enabled

• Tool. The order of the columns are modified when datatype is changed

• Logical Project. Mapping data is not created for copied projects

• FE. Column Template comment is wrongly added to the SQL script creating an invalid script

• Tool. BigQuery. Only 1 error message is returned for service

• Amazon Redshift. Schema description is not added to the merge process

• Tool. Concurrent Working. “Apply and go to next” button is enabled during merge

Logical

• Launch the SQLDBM UI with menu and Properties pane hidden for Consumer/View only users

• Logical project. Import from physical

• Logical project. Visibility (logical only / physical only)

• Logical Project. Discriminators. Report pages

• Logical project. Export. User can’t export project without changes

Subtypes for Logical projects and loads of other data modeling enhancements in this release. Click the heading to see the full list 👆

Changes with no impact on existing DDL/API functions

Logical

• Logical project. Discriminators (subtypes/supertypes)
• Logical Project. Selective export to a physical project

Data modeling

• Postgre. Partitioning key MVP
• Snowflake. Environments. Object filtering improvements
• Databricks. Quotes and default values
• Update display of the relationships
• Reverse Engineer Compare popup adjustments
• Oracle. After creating a table with a specific index then the post script, comments, and keys are not added to the FE script
• Global Reference. Global objects are not updated when a revision is deleted on the Global project
• Tool. BigQuery. Error message is present when user adds hypens to the project name inside views
• Global Reference. Context menu is not displayed in Database Explorer
• Global Reference. Schema name is missing for Global objects
• Global Reference. Global objects are disappearing after updating model via RE
• Global Reference. Concurrent working, Virtual Relationships between a Global object and a Local object are not getting merged
• Global objects are not highlighted when clicking “+ Add comment” in Team comments
• Global Reference. Global objects border doesn’t highlight with blue when selecting them with Multiselect tool
• When global object is selected, other nodes are not dimmed
• Import. Logical. Custom field information is not updated on Column Templates added to a specific table
• Tool. Relationships lines overlap on multiple relationships added to the same object
• Log. Errored connections to Databricks causes user connection details to be logged in plain text
• Logical Project. Template Column Tab shows “Logical Name” Column instead of Physical Name when user exports a Logical Project
• Logical project. Export to Azure
• Logical project. Export to Databricks
• Report page. The system doesn’t display fields on the ‘Fields’ tab
• Add null check to copy project/ copy flags functionality
• PostgreSQL. Some Datatypes are still missing in the dropdown
• PostgreSQL. The user is getting an error when creating relationships between tables of different schemas
• Redshift remote connection fails for SHA256 encrypted passwords
• Reverse Engineer. COPY GRANTS is not correctly supported if the user add the instruction before the column list

Schema Monitoring

• Stop monitoring job after 10 failed connection attempts

Logical modeling enhancements and lots of new functionality for Postgre. Click the heading to see the full list 👆

Changes with no impact on existing DDL/API functions

Data modeling

• Sql Server. Direct Connect

• Postgre. Errors and warnings

• Postgre. Missing data types

• Postgre. Views

• GBQ SSO

• Snowflake RE object filtering

• Logical project. Onboarding

• Logical project. Improvements (styles&texts)

• Logical project. “Missing logical data type” is still visible and doesn’t allow users to save mappings

• Dashboard. Highlighting the row with the opened context menu

• Style dropdown lists

• Data preview. Alert should be displayed in the “Data preview” console

• Compare screen for RE import

• Replace empty case icons

• Delete object popup. Change text

Business Critical

• Remove Audit logs limitations

• Business Critical - Google Cloud storage

Logical projects with custom data type mapping and conversion are now available! Click the heading to see the full list 👆

Changes with no impact on existing DDL/API functions

Data modeling

• Logical projects
• Data Preview (add-on)
• BQ. Direct connect. Get information about the region
• New "Settings and conventions" project menu
• Reverse Engineering. Fix: Add list is not working properly after performing certain actions

Redshift direct connect, Table Templates for Databricks and Synapse, and diagram cloning! Click the heading to see the full list 👆

Changes with no impact on existing DDL/API functions

Data modeling

• Databricks. Table Templates (Standard Enterprise and above)
• Azure Synapse. Table Templates (Standard Enterprise and above)
• Amazon Redshift. Direct connect
• Duplicate diagram
• Direct Connect SSO work with external S3 + Tests
• dbt properties. Sources. Template update
• Add support for Azure Active Directory Authentication in Azure Synapse
• Reverse engineering - add list is not working properly after performing certain actions
• Fix Table Template. The color is reset to none when the user selects or changes the schema for that table
• Fix Naming Conventions not being applied correctly for relationship name
• Fix GBQ. Array column parsed and displayed incorrectly
• Save large project performance enhancement

Global Modeling

• Global Modeling - Enabling global project (Dashboard)
• Global Modeling - Group global objects in compare revision screen by project
• Global Modeling - Virtual relationship improvements

Data Governance

• DG Pages. External S3 storage security