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

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

Mini release that includes performance improvements for project saving and API behavior.
Click the heading to see the full list 👆

Changes with impact to existing DDL/API functions

API

• Improved consistency in API response
  While the structural format of the data will remain the same, there will be enhancements to the completeness of the information it contains.
  • Changes to JSON Data:
    • More Comprehensive Data:
      The JSON will now include additional fields, particularly for properties that previously might have been omitted if they only held default or null values.
    • Distinct Handling of Empty Strings and Nulls:
      We are updating our data processing to more explicitly differentiate between empty strings (“”) and null values. Going forward, an empty string in the JSON data will represent exactly that—an explicitly provided empty string. Conversely, if a value is not provided, it will be represented as null.
    • Slight Increase in Data Size:
      As a result of these enhancements, the overall size of the JSON data might see a modest increase.
  • What This Means for You:
    • Review Data Handling Procedures:
      We recommend a review of how your applications handle and process our JSON data.
    • Possible Adjustments in Data Processing:
      Depending on your current implementation, slight modifications in your data parsing or processing logic may be needed.
  • Some examples of changes you may experience going forward:
    • More Comprehensive Data:
      • Before: mySql: {}
      • After: mySql: {collation: null, generatedExp: null}
    • Distinct Handling of Empty Strings and Nulls:
      • Before: comment: ""
      • After (may look like): comment: null
      • You may still receive empty strings only if they are explicitly declared to be stored this way.
  • Our team is ready to assist you with any queries or support you might need during this transition! Please feel free to reach out to us at [email protected], raise a support ticket in the support forum, or reach out to your Account Manager or Support Agent personally.
    We are committed to continually improving the quality and usefulness of the data we provide and appreciate your understanding and partnership as we implement these enhancements. Thank you again.

Changes with no impact to existing DDL/API functions

Data modeling

• Improved performance in saving of large projects

All dbt properties are now editable along with the relational model. The Data Governance Reports page can be shared to Confluence. Status page for tool/API/monitoring functions is also coming. Click the heading to see the full list 👆

Changes with no impact on existing DDL/API functions

Enterprise Plus

• Audit logs. Apply button for Filter
• Audit logs. Items are not displayed in the table due to the lack of page number when changing dates/searching

Data Governance

• Report page. Confluence macros

Schema Monitoring

• Icon buttons don't have a hover effect: expand icon and three dots icon
• Increase the clickable area for the Visual Changelog icon
• Remove autogenerated comments from SQL on compare
• Visual changelog. Complete Schema and Job name is not filtered by search

Data Modeling

• Site. Status page
• All objects on a diagram look like updated
• Change Table view mode to Conceptual view mode
• Concurrent working incorrect flags display if a user creates templated table with flags
• Creating schema from selecting dropdown
• Dashboards. Arrow icon bold format
• Dashboards. Title bold format
• Dashboards. Unnecessary scrollbar appears
• Databricks. Some table's properties are missing
• DB Documentation. Add target objects property for dbt fields
• DB Documentation. Export target objects property for dbt fields
• dbt fields extended. Concurrent working
• dbt fields extended. Documentation
• dbt fields extended. Generate YAML
• dbt fields extended. Import/export XLSX
• dbt fields extended. Report pages
• Diagram. Script panel improvements
• GIT|AWS. Unable to push source DDL to git for the specific project
• GIT|Gitlab. Unable to push source DDL to git for the specific project
• GitHub integration isn't created
• Snowflake SSO. Add a message if we can't get databases for role
• Suggest relationship. Add sorting
• Table templates. Applying sequence and default options for column
• Table templates. Incomprehensible error in tooltip for table template
• Table templates. logicalName is not being used for physicalName when physicalName is missing
• Table templates. Name of the new template starts with capital letter
• Table templates. New template names don't reflect the name property by default
• Tool. "Productivity tips" in Help menu leads to a non-existing page
• Tool. The value in the datatype is not saved if selected from the suggested
• Tool: Analyze all views does not show warning when there is a syntax error
• Can’t add object to the diagram after removing all diagrams and creating new one
• Default table templates updates

YAML table templates are here, and so are long-awaited multi-select explorer options!
Click the heading to see the full list 👆

Changes with impact to existing DDL/API functions

API

• Open API. Get for Specific object name. Add schema name
  • the "objectName" will now return fully-qualified object names (e.g., "dbo.customer" instead of "customer") to make similarly named objects from differing schemas easier to reconcile.

Data modeling

• Snowflake - Column alter script 'RENAME TO' instead of drop and create
  • renaming a column will generate an ALTER TABLE t RENAME COLUMN old TO new script instead of dropping and adding a column. This feature will also work for Alter Scripts generated using Environments (when column position and data type matches)

Changes with no impact to existing DDL/API functions

Enterprise Plus

• IP Listing. Send an error on invalid IP
• IP access management. Validate duplicated IP
• IP access management. ‘Comment’ area
• IP access management. Error when a blocked user sends the request

API

• Open API. ReadMe. Change ‘Projects’ to ‘Methods’

Data modeling

• YAML Table Templates
• Tool. Error when exporting documentation when there are no tables in the project
• Audit logs. Available for Admins only
• Help menu. New updates. Change link
• Do not allow duplicated object names
• Diagram. Script panel improvements
• Diagram. Single table context menu
• Diagram. Bulk selected tables context menu
• Diagram. Single table column context menu
• Diagram. Bulk selected table columns context menu
• Diagram. Single view/function/procedure context menu
• Diagram. Bulk selected views/functions/procedures context menu
• Confluence integration. Show selected subject area
• Tool. Update ‘Editing by...’ text
• Dashboard. Update ‘Editing by...’ text
• SSO for Direct Connect. Improvements
• Snowflake. Can’t parse and generate reference comment / Ticket
• Admin User doesn’t have the possibility to give Edit access to projects when not the owner
• Generate Alter Script doesn’t show the actual changes between revisions / Ticket
• Snowflake. Can’t analyze secure function 
• Save project doesn’t work for big project
• RE. Error warning on Reverse Engineer when Importing with ‘Masking Policy’ / Ticket
• BigQuery. During RE we say we will skip the line but we actually bring it into the tool
• BigQuery. False Warning for Syntax error, unexpected ‘>’

Data Governance

• DG. No end (double) quote for single quoted values / Ticket
• DG. Pages. Add ‘Report page’ icon

Schema Monitoring

• DBSM. Visual changelog. Add search component
• DBSM. Visual changelog. Add day/week selector
• DBSM. Show visual changelog near Job name