Author: Emmanuel Ikpesu

Date: 2nd March 2024

Event: DBT-Lagos-Meetup Community Link

Ms. Fabric is Microsoft's latest all-in-one analytical platform, and it's designed to give a hands-on experience on integrating dbt with Fabric.

This Project is built using the DataTalksClubs Analytical Engineering as starter with a tweak to fit T-SQL, Microsoft Fabric, GitHub and dbt

• Ms. Fabric Core Concept
• DBT Integration with Fabric

• Ms. Fabric Account
• A dbt Cloud Account
• A GitHub Account
• Basic Understanding of Python & SQL
• Fundamental Knowledge of Analytical Engineering

• Fork This Project to your git profile, create a branch named dev. This is the repository you would be linking to your dbt account.
• Give DBT adequate access to connect to this repository on your git provider (github/gitlab) -> see steps
• Create a dbt project with the name fabric_dbt_integration or any name of choice and point it to the dbt subdirectory of this repository.

1. Create a Fabric Workspace.
2. Create a Data Warehouse, and load data into it.
3. Fork GitHub Repo
4. Creat dbt project
5. Like dbt project to Fabric and GitHub
6. Run dbt job.
7. Preview result.

The Structure of this project was adapted from the DataTalksClubs Analytical Engineering Code. Docs are available at the following Links

• DataTalksClubs
• Microsoft Fabric
• GitHub
• dbt Cloud

The compilation of this project was inspired with ❤️ by the dbt-lagos-community 📦 .

===========================