VaultSpeed Release 5.6.2 | Subqueries in automation… | VaultSpeed

VaultSpeed launches new enhancements to templates and data modeling (Release 5.6.2)

February 19th, 2024

Release 5.6.2 includes enhancements to templates and data modeling. The VaultSpeed template studio now supports subqueries in expressions. We have also improved the performance of the link-across-source loading logic and added the ability to detect name changes on existing foreign keys in the source.

DSC08181 2
Jonas De Keuster VP Product Marketing
Release 5 6 2 Resource Image 876x640

Template subquery support

We are excited to announce that our template language now supports subqueries in expressions! This new feature allows you to create a component group of type SUBQ_GRP, which functions like a CTE with an INL_V_GRP. Once you have created your subquery component group, you can easily reference it in other component groups by using the syntax SUBQ() in your expressions. However, please note that subqueries can only be used within expressions and not as source or join components.

For instance, you can use subqueries in the WHERE clause to filter query results based on conditions derived from other tables or aggregated data. This can include scenarios like comparing values to averages, filtering based on existence or non-existence in related tables, and selecting records based on specific criteria like departmental associations or order dates.

We hope you find this new addition to our template language helpful!

Screenshot 2024 02 13 at 15 06 31
Screenshot 2024 02 13 at 15 25 11

Renamed FK detection

At times, source systems tend to change the names of foreign key relationships which can be quite frustrating. This issue typically arises while integrating systems with system-generated FK names. Earlier, if a primary or foreign key in the source was renamed, VaultSpeed would add the renamed key as a new one and disable the old one. Such changes can have an adverse impact on the resulting integration model.

In version 5.6.2, we have added a new feature that allows automatic recognition of any changes in the name of primary or foreign keys in the source model. As a result, the key name in VaultSpeed’s metadata repository will be automatically updated without any manual intervention. This update will eliminate the need for any manual adjustments to the model.

Other changes

We made the following updates:

  • Improved the Business key ordering screen to make it more intuitive.
  • The application now displays a warning message at the top of every page a few hours before a maintenance window. Any running tasks will be automatically canceled during maintenance and resumed afterward.
  • Fixed the default data type mapping for Numeric in Snowflake. It now properly retains the sizes as defined in the source.
  • Fixed an issue with type conversion in the SAT Hash Difference calculations when data quality is bad.