Version 0.7.2

[v0.7.2] - 2021-01-26

New

• Derived columns can now be provided lists, for creating composite column values. (#20)
  Docs

• The hashed_columns exclude flag in staging can now be provided without a list of columns, and dbtvault will hash everything. Docs

• Rank Load Materialisation: Iteratively load your vault structures over a configured ranking Read More

• The stage macro now has a new ranked_columns configuration section to support the above materialisation. Read More

Improved

• Optimised Satellite SQL for larger loads (billions) seen in the wild.
• For non-hashdiff composite hashed_columns: If all components of the key are NULL, then the whole key will evaluate as NULL.
  Read more
• Hashing concatenation now uses CONCAT_WS instead of CONCAT; this is more concise.
• The stage macro has received a big overhaul, and the SQL should now be more efficient and easier to read.
• Optimised table macro SQL across the board by reducing the number of CTEs

Fixed

• Fixed multiple (minor) bugs in the stage macro (#21)
• Fixed and improved the adapter.dispatch implementation (#22)
• Fixed a bug in the vault_insert_by_period materialisation (#19)

Docs

• Added examples of different ways to provide metadata to the metadata reference
• Added a short guide on extending dbtvault
• Updated all SQL snippets to reflect changes