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

Snowflake Direct Connect SSO, along with IP access management and audit logs for Enterprise Plus, and a visual changelog for Snowflake Schema Monitoring! Click the heading to see the full list 👆

Enterprise Plus

• IP Access Management
• Audit logs

Data Modeling

• Snowflake. SSO. Azure AD  
• Databricks rename table/column in Alter script
• RE. Unmark suggested relationships 
• FE. Alter script popup. Add more space for revision name
• SF. Tags. Can’t import script with a non-existing tag 
• Add RE script to logs on RE  
• BQ. Pop up with choice when a user deletes STRUCT  
• Alter SSO configs without server restart  
• Easy invitation. Send an email to the project owner  
• Naming conventions. Update component of the reusable parameter  
• Unconfirmed email signup with OAuth  
• Issue with CW projects after changing Standard Ent to Small Ent
• SF. Tags. Can’t filter objects on the diagram by tag inherited from schema   
• SF. RE. No error message is returned in direct connection with IP policy enabled 
• Tags are generated without the schema information after copying them from one project to another 
• Import Documentation is not applying changes done to XLS 
• SF. RE. Errors on Auto Increment syntax 
• RE. Postgre. Can’t parse NULL Columns with default value and default now() 
• List of suggested VPK/VFK scrolls up periodically 
• Simplified registration does not work for SSO 
• User gets stuck on the Merge screen for a project with a large number of relationships 
• Some users cannot add themself to a group that has projects 
• Databricks. Views are not analyzed
• Something went wrong in the project team page in WCBM when transferring the project

Schema Monitoring

• Visual changelog
• Allow consumers to access DBSM
• DBSM. Save DBSM data as a project  
• DBSM. Increase the number of saved DB versions

Data Governance

• DG. No end (double) quote for single quoted values
• DG. Page. Add link. Search

API command for retrieving a single object, Excel import/export support for Data Governance fields, and more. Click the heading to see the full list 👆

API

• API. GET DDL of the specific object by name

Data modeling

• FE. Remove revision number from comment

• Suggested relationships. Patterns popup. Change radio button name

• Broken highlights for view in Column-view-lineage

• Diagram. Object context menu. Remove Clone item

• GBQ. STRUCT Improvements

• Easy invitation. Send an email to the project owner

• User projects. Only an Icon was displayed without username

• Snowflake. Views with sub-queries are not recognized when importing

• Import Documentation is not applying certain changes done via XLS

Data governance

• DG. Fields included in Excel Import/Export
• DG. Field types and values in Excel upload
• DG. Pages. Redo and Undo
• DG. Pages. Page template updates
• DG. Pages. Add a link to another Page
• DG. Pages. Topbar tooltip improvements
• DG. Pages. Allow to delete unsaved pages
• DG. Pages. On the Spanish keyboard, pressing Right Alt + 2 triggers Header 2 hotkey

Schema Monitoring

• DBSM. Save as a project. Admin updates

Alter script support for Google BigQuery, easy project sharing, fixes and enhancements to projects and governance, and more. Click the heading to see the full list 👆

Data modeling

• GBQ. Alter script support
• Easy invite option for project collaborators to invite users
• Redshift. SUPER data type
• Snowflake. Sequence. Do not skip sequence when importing
• GBQ. Change ‘Case-sensitive’ checkbox
• GBQ. Direct connect errors update
• GBQ. Display error from the backend to the user
• Snowflake. Single line SQL. Incorrect syntax near: ‘rely’
• Visual issues on User Groups display names
• CW. Errors after converting a Concurrent Working project
• Snowflake. Unable to parse procedure with “LANGUAGE PYTHON”
• Snowflake. ALTER statement for setting TAG at object level missing SCHEMA name
• Snowflake. Alter statement with TAG and Comments in not executable in Snowflake
• Alerting. View name with error is not being specified
• GIT. Can’t push create and drop table sql files to Azure DevOps
• Databricks. Unknown table properties imported via Unity catalog
• Error when user trying to sign in via Microsoft
• Error on Copy Project Action

Data governance:

• DG. Stylize email links
• DG. Pages. Import file and skip unknown objects
• DG. Pages. Add tooltip for "Highlighting" button
• DG. Report page. Show tooltips for external links