Release v24.8.1 Sept 12, 2024

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