September 16, 2024

How to Connect Microsoft Fabric with dbt Developer Hub?

Learn to connect Microsoft Fabric with dbt using the dbt Developer Hub. Clone the demo project, install the adapter, and update profiles.yml for setup.
Dexter Chu
Head of Marketing

How to Connect Microsoft Fabric with dbt Developer Hub?

The dbt-Fabric adapter allows you to connect Microsoft Fabric with the dbt Developer Hub. Start by cloning the jaffle_shop demo dbt project onto your machine. Open the project folder in Visual Studio Code and install the new adapter. Update the type property in the profiles.yml file and build the project. The standard SQL server port number, 1433, is the port to connect to Microsoft Fabric.

  • Cloning the project: This involves copying the jaffle_shop demo dbt project onto your local machine for further use.
  • Installing the adapter: The new adapter is a necessary component that enables the connection between Microsoft Fabric and dbt.
  • Updating the profiles.yml file: This file contains the type property that needs to be updated for the connection to be established.

What are the Authentication Methods for Microsoft Fabric?

Microsoft Fabric supports two types of authenticated users: Microsoft Entra ID (formerly Azure Active Directory) user principals and Microsoft Entra ID (formerly Azure Active Directory) service principals. These authentication methods ensure secure and verified access to the Microsoft Fabric.

  • Microsoft Entra ID user principals: These are individual users who have been authenticated by Microsoft Entra ID (formerly Azure Active Directory).
  • Microsoft Entra ID service principals: These are services or applications that have been authenticated by Microsoft Entra ID (formerly Azure Active Directory).

What are the Requirements for SQL Connection String?

The SQL Connection String requires TCP port 1433 to be open. It also respects the Warehouse or Lakehouse SQL analytics endpoint security model for data access. This ensures a secure and reliable connection to Microsoft Fabric.

  • TCP port 1433: This is the standard SQL server port number that needs to be open for the SQL Connection String.
  • Warehouse or Lakehouse SQL analytics endpoint: The SQL Connection String respects the security model of these endpoints for data access.

How does dbt Connect with Data Platforms?

dbt connects with data platforms by using a dedicated adapter plugin for each. These plugins are built as Python modules that dbt Core discovers if they are installed on your system. This allows dbt to interact with various data platforms efficiently.

  • Adapter plugins: These are Python modules built for each data platform that dbt can connect with.
  • dbt Core: This is the main component of dbt that discovers the installed adapter plugins on your system.

What is the Role of the dbt-Fabric Adapter?

The dbt-Fabric adapter plays a crucial role in connecting Microsoft Fabric with the dbt Developer Hub. It is a Python module that dbt Core discovers if installed on your system, enabling the connection and interaction between the two platforms.

  • dbt-Fabric adapter: This is a Python module that enables the connection between Microsoft Fabric and dbt.
  • dbt Core: This is the main component of dbt that discovers the installed dbt-Fabric adapter on your system.

Keep reading

View all