Project Setup
Database Setup in SQL Server
A database is created in SQL Server to store the data warehouse and data marts. This involves:
-
Setting up the SQL Server instance.
-
Creating schemas for data marts.
-
Implementing tables based on the dimensional model.
-
Establishing indexes and constraints for optimization.
Setting Up DBT Development Environment
DBT is used to manage transformations and ensure data quality. The setup process includes:
-
Installing DBT and configuring it to work with SQL Server.
-
Defining a DBT project structure.
-
Connecting DBT to the SQL Server database.
-
Version-controlling the project using GitHub.