DataVault4dbt - A Comprehensive Guide

3. SETUP INSTRUCTIONS REQUIREMENTS

To use the macros efficiently, there are a few prerequisites you need to provide:

— Flat & Wide Source Data: Ensure that your source data is flat and wide, and available within your target database

— Load Date Column: This column should represent the arrival time of the data in the source data storage. Can be generated with DataVault4dbt, if not present — Record Source Column: This column should give information about where the source data is coming from (e.g., the file location inside a Data Lake). Can be generated with DataVault4dbt, if not present INSTALLATION INSTRUCTIONS 1. Include the Package in your packages.yml: • Open your packages.yml file in your dbt project directory • Add the following lines to include the DataVault4dbt package:

packages: - package: ScalefreeCOM/datavault4dbt version: [Insert latest version here]

10/18