search

Datavault-UK / automate-dv

A free to use dbt package for creating and loading Data Vault 2.0 compliant Data Warehouses (powered by dbt, an open source data engineering tool, registered trademark of dbt Labs)
https://www.automate-dv.com
Apache License 2.0
478 stars 114 forks source link

[FEATURE] - Packages for creating information marts #218

Open AdMcG64 opened 7 months ago

AdMcG64 commented 7 months ago

Is your feature request related to a problem? Please describe. Not, not a problem but a good enhancement IMO. I am not seeing packages to help with creating information marts.

Describe the solution you'd like Packages to assist with information marts resulting in outcomes as described at: https://www.vertabelo.com/blog/data-vault-series-building-an-information-mart-with-your-data-vault/

Describe alternatives you've considered DIY using SQL

Additional context Great work this BTW.

AB#5355

DVAlexHiggs commented 6 months ago

Hi, welcome to the community and thanks for the suggestion! This is planned and on our roadmap; we're looking to get more features in to the Raw Vault layer and general quality of life improvements before we look at providing helper functions for downstream layers.

The thing to remember is that in most cases, the presentation layer is highly bespoke and depends on the organisation , and thereby you should and can build your own using standard dbt functionality.

With that said, there are certainly some re-usable macros and standard functionality that we have thought about and found we need in our own AutomateDV projects, that we want to bring to the community