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

Tx

• Tx. OpenAPI. Logs for Flows, Runs and Deploy
• Tx. Enhanced new Tx project workflow onboarding
• Tx. Add identity property to columns
• Tx. Hub, Link, and Satellite templates
• Tx. Unclassified objects in ERD

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

Tx

• Tx. OpenAPI. Logs for Flows, Runs and Deploy
• Tx. Flows small grammar adjustments to case and wildcard
• Tx. Database explorer. Delete tx object
• Tx. UI/UX improvements 24.10.1
• Tx. Add where condition property to Tx objects
• Tx. Allow for multiple statements for pre/post-SQL items
• Tx. Tabs. Unsaved changes
• Tx. User Connections. Show Data preview alerts in the Results tab
• Tx. add ${parentRef} template variable
• Tx. Show indicators for failed executions
• Tx. Change Tx Template for a Tx Objects
• Tx. Change storage structure for columns assigned to Column Sets
• Tx. Add property useQuotes to Tx templates and objects
• Tx. Preview in Tx Templates

Tx Flows for data pipeline automation and an API to trigger them remotely. This release also 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

Tx

• Tx. Flows. MVP
• Tx. OpenAPI. Logs for Flows, Runs and Deploy
• Tx. Team collaboration. New version notification should not be shown
• Tx. Team collaboration. Remove redundant alert
• Tx. Macros. Current tab isn’t look like selected
• Tx. Macros. Tab isn’t deleted after removing macros
• Tx. Locations. Unable to delete location in non-TX project when there is only one location
• Tx. Database explorer. Can’t delete tx object
• Tx. Deleting environments doesn’t work
• Tx. Exclude password from environments response

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

Deployment and orchestration for Tx workflows plus 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

Tx

• Tx. Flows

• Tx. Deployment

• Tx. Environments

• Tx. Team collaboration. Modelers

• Tx. Truncate before

• Tx. Macros

• Tx. Change confirmation popup

• Tx. Add parameters to project and environments

• Tx. Split Tx ref lines evenly along the edge of the object so they don’t overlap

• Tx. Edit tx object columns. UI updates

• Tx. Allow for Parameters to be referenced

• Tx. Show Data preview alerts in Results tab

• Tx. Refresh to display alert if there are no changes

• Tx. Inherit from parent ColumnSet

• Tx. Small adjustment to “Select data” syntax

• Tx. Include column name in columnSets columns

• Tx. Improvements to default templates

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 Tx enhancements like refs on relational, more ref types, and new templates. Click the heading to see the full list 👆

Changes with no impact on existing DDL/API functions

Tx

• Tx. ERD diagram. Show Tx references
• Tx. Persistent Stage template
• Tx. ERD. Add ‘Change branch’ icon to Top bar Menu
• Tx. PrePostSql validate toggle addition
• Tx. Create new ref types (link, text, this)
• Tx. Locations. Search. Sequences and tags are not being displayed in search result when searching by full name(location + object) on Forward Engineer
• Tx. Locations. Search. Location’s objects are not being displayed in search result on database explorer page
• Tx. Locations. ‘Add new’ button is not displaying in location dropdown in table edit mode
• Tx. Locations. Mapping of default location is not being changed after switching default location
• Tx. Locations. Script with existing objects without mapping considering as ‘Updated’
• Tx. Relational part. No AK label
• Tx. Relational part. Sources. No new icon in Reverse Engineer
• Tx. Relational part. Tx-based objects. PE
• Tx. Tx explorer. Add plus icon for locations
• Tx. Tx explorer. Default location shall have context menu
• Tx. Tx explorer. Wrong name
• Tx. Connection. Git integration. Not contrast icon for azure and bit bucket
• Tx. Connection. Git integration. Can’t get branches when changing connection with different git
• Tx. Connection. Git integration. Error styles
• Tx. Schema name is shown on ERD diagram instead of location mapping
• Tx. Tx object and relationships disappearing from the ERD diagram after Reverse Engineer
• Tx. Forward Engineer. deselect all tables isn’t working
• Tx. Fix. New options isn’t added to the yaml if user didn’t change it
• Tx. Sources. Add counter in the Add [n] source
• Tx. Tx object details. Change alert if structure doesn’t match the snowflake
• Tx and Rx projects should open “draft” revision by default
• Tx. User Connections/Locations. Leave without saving
• Tx. Improve formatting in new node SELECT with CTE format
• Tx. Table is expanded after clicking on “Add to diagram” button in Database Explorer
• Tx. Wrong swagger description for get commits list
• Tx. Final stage of selection user connection is broken
• Tx. Explorer. Groups of objects alignment
• Tx. Add source. Rename tab
• Tx. Add source. No selected sources but the add source button is available
• Tx. Update multiple environments does not work
• Tx. Storage locations. “Leave without saving?” pop-up is appearing after applying changes to location
• Tx. Title and name of template doesn’t change after duplicate action
• Tx. All script in parameter sqlScript sent in uppercase in request /tx/run
• Tx. Show location on Tx diagram
• Tx. Unblock force checkout for current branch

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

Tx

• Tx. Flows — there is a vast DevOps part that is not estimated yet

• Tx. Rename “Display” to “Display name”

• Tx. Web. Add Tx Tokens

• Tx. Locations. Add schema to locations

• Tx. Tx object. Open Results after validation

• Tx. Location. User is able to parse object for deleted location

• Tx. Locations. Script with existing objects without mapping is considered as ‘Updated’

• Tx. Tx object and relationships disappearing from the ERD diagram after RE

• Tx. Locations. Mapping of default location is not changed after switching the default location

• Tx. Relational part. Tx-based objects. All columns are always displayed

• Tx. Relational part. Sources. No new icons in RE and FE

• Tx. Relational part. Tx-based objects. No warning when updating object via RE

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

Global Modeling is finally here with the introduction of Global Reference capabilities and lots more!
Click the heading to see the full list 👆

Changes with no impact on existing DDL/API functions

Data modeling

• Global Modeling - Global Reference (Standard Enterprise and above)
• Table Templates - Google BigQuery (Standard Enterprise and above)
• Dbt Properties - Sources
• Azure Synapse. External tables
• Table templates transient and data retention configuration for Snowflake
• Table templates. Apply column template via table template
• Table templates. Disable script editor for default templates
• Table Templates. Add virtual or physical relationships
• Concurrent Working. Branches. Add context menu
• Performance enhancement for saving large projects
• View Column lineage performance enhancement
• Fix. Naming convention issue with tables
• Fix. Admin Unable to Transfer Ownership
• Fix. FE import generating additional DDL statements in the script
• Fix. Merge on diagrams is not shown in confluence
• Fix. Index properties are not working on MySQL
• Fix. Tags are generated without the schema information after copying them from one project to another
• Fix. Reserve word “Period” on column name creates a warning on RE in Microsoft SQL server table creation
• Fix. SQL Server wrong default options for PK
• Fix. SQL Server. Mark constraint option in FK by default

Data Governance

• Data Governance. Pages. Add data stewards in Summary
• Data Governance Pages. External S3 storage security

Enterprise Plus

• Direct Connect SSO for Enterprise Plus

External tables for Databricks and lots of dbt enhancements in this release. Click the heading to see the full list 👆

Changes with no impact on existing DDL/API functions

API

• API. Get dbt YAML

Data modeling

• Databricks. External tables
• Databricks. Default column constraint
• Views on logical diagrams
• dbt constraints and datatypes
• Diagram Warnings. Add table name for column/key/index
• Concurrent working. Merge visualization improvements
• Databricks. ‘Timestamp_’ datatype support
• Project collaborators popup. Change placeholder
• Snowflake. Schema, table, constraint alter script ‘RENAME TO’
• Snowflake. Open API. Schema, table, constraint alter script ‘RENAME TO’.
• Snowflake. Filter by inherited tags
• IP access management. Display warning
• IP access management. Adding IPs with *
• Update OpenApi to account for Azure External Storage
• Confluence. Report Page. Access denied
• Concurrent Working. Unmerge related objects
• Concurrent Working. Improvements
• FE. Create schema for the selected object
• Databricks. Show warning when importing unsupported options via UC
• Unable to import schema dump for PostgreSQL
• Fix View column lineage display error
• Confluence. Fixed object height always applying
• Lineage for view is not shown after importing it
• The columns are missing when SELECT * is used in a view
• Admin Unable to Transfer Project Ownership
• GBQ. RE. Syntax warnings for VALUES column
• FE import generating additional DDL statements in the script
• Merge on diagrams is not shown in confluence
• Concurrent working merge issue for subject areas
• Views not mapped into the correct Schema, but table are being mapped to the correct schema
• Self Join tables are not reflecting correct related objects (parent - child)
• GBQ. Can’t parse week column name
• Concurrent Working. Column flags are not merged to master branch
• Concurrent Working. Issue While Merging Diagrams
• Naming convention issue with tables
• Tags are generated without the schema information after copying them from one project to another

Data Governance

• Pages. Naming for export file
• Pages. Add link to diagram and subject area

Enterprise Plus

• Add Data Governance Pages to external S3 storage security