05 Sep Using macros in dbtvault – Hubs
Hubs in dbtvault
Welcome back to our series of videos about dbtvault, in which we will be showing you dbtvault tips and tricks, aimed particularly at beginners. This is the second video in the series “Using macros provided in dbtvault”. Alex, the lead developer of dbtvault, will show you how to create a hub in dbtvault and show you the lineage of all data flowing to the created hub.
This is a continuation from the first video and Alex assumes that you have a stage view created using the dbtvault stage macro. If you missed that video, click here to watch it
We start off by creating a hubs folder, within the raw vault folder. This is a good practice to keep things tidy and organised. Once this has been created, Alex proceeds to populate the hub with metadata which he takes from the staging area he created earlier called “v_stage_orders”.
Now that the metadata has been provided, we need to provide the macro call for the dbtvault macro. You can find the code he is using in the dbtvault documentation or just type it out as shown in the video. You can find the dbtvault documentation here.
Near the end of the video – Alex opens snowflake to demonstrate the created hub and generated documentation to show you the lineage of all the data flowing to the hub “CUSTOMER”
Look out for the next video which will be about Links. Lastly, we offer support for dbtvault – which you can find out more about by clicking here.