Microsoft Fabric - Paradime

Microsoft Fabric is a unified analytics platform that combines data warehousing and analytics services. Connect it to Paradime to develop dbt™ from the Code IDE, deploy production jobs with Bolt, and run dbt™ models and queries during Agent background sessions.

IP restrictionsMake sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.See also: Paradime IP addresses.

Available in: Code IDE, Bolt, and Agent environments.

Authentication methods

Microsoft Fabric uses Microsoft Entra ID (formerly Azure AD) as its primary authentication system. Set authentication to one of these values:

ActiveDirectoryPassword - Microsoft Entra ID username and password
ServicePrincipal - Service principal authentication

Add a connection

Click Settings in the top menu bar of the Paradime interface to access Workspace Settings.
In the left sidebar, click Environments.
Click Add New next to the section for the environment you are configuring:
- Code IDE for the Code IDE connection
- Bolt for the Bolt connection
- Agent for the Agent connection
Select Microsoft Fabric.
In the Profile Configuration field, add the parameters for your authentication method (see Profile configuration below). Reference the Profile fields reference for additional context and configurations.
Provide a dbt™ Profile Name (this should match the profile name set in your dbt_project.yml).
In the Target field, enter the target for the environment you are configuring: dev for Code IDE, prod for Bolt, or dinoai for the Agent.
The Schema field is pre-configured, but you can change it to specify the schema where dbt™ will build objects.
The Threads value is pre-configured to 1, but you can adjust this to specify how many parallel operations your dbt™ project can run.

Profile configuration

Add the following parameters based on your authentication method.

Microsoft Entra ID username and password
Service principal

driver: 'ODBC Driver 18 for SQL Server'    # ODBC driver name
server: fabric.analytics.com               # Server hostname
port: 1433                                 # Default port
database: analytics_db                     # Database name
schema: reporting                          # Schema name
authentication: ActiveDirectoryPassword    # Password authentication
user: user@company.com                     # User email
password: your_password                    # User password

driver: 'ODBC Driver 18 for SQL Server'    # ODBC Driver for SQL Server
server: fabric.analytics.com               # Server hostname or IP address
port: 1433                                 # Server port number
database: analytics_db                     # Database name
schema: reporting                          # Schema name
authentication: ServicePrincipal           # Authentication method
tenant_id: your_tenant_id                  # Microsoft Entra tenant ID
client_id: your_client_id                  # Application (client) ID
client_secret: your_client_secret          # Client secret value

After adding the configuration, ensure it’s properly formatted using a YAML formatter like YAML Formatter.

Schema authorization

When creating schemas in Microsoft Fabric, you can control who owns them:

Schema ownership is defined using the AUTHORIZATION Argument. The syntax follows this pattern:
CREATE SCHEMA [schema_name] AUTHORIZATION [schema_authorization]
Useful for managing permissions in Microsoft Entra ID environments.
Recommended when working with group-based permissions.

Profile fields reference

Field	Description	Example	Default	Required
driver	ODBC driver	`ODBC Driver 18 for SQL Server`	`ODBC Driver 18 for SQL Server`	✅
host	SQL analytics endpoint	`localhost`	None	❌
port	Server port number	`1433`	`1433`	✅
database	Database name	`analytics_db`	None	✅
schema	Schema name. Configured in the UI Schema field.	`dbo`	`dbo`	✅
authentication	Authentication method	`ServicePrincipal`	`sql`	✅
retries	Number of connection retry attempts	`1`	`1`	❌
encrypt	Enable connection encryption	`true`	`true`	❌
trust_cert	Trust server certificate	`false`	`false`	❌
login_timeout	Connection timeout in seconds	`0`	`0`	❌
query_timeout	Query timeout in seconds	`0`	`0`	❌
schema_authorization	Schema owner principal	`db_owner`	None	❌
UID	Username for authentication (when required)	`fabric_user`	None	❌
PWD	Password for authentication (when required)	`your_password`	None	❌
tenant_id	Microsoft Entra ID tenant ID (for service principal)	`your_tenant_id`	None	❌
client_id	Microsoft Entra service principal client ID	`your_client_id`	None	❌
client_secret	Microsoft Entra service principal client secret	`your_client_secret`	None	❌

Optional connection attributes

Set additional profiles.yml attributes for this connection.

​Authentication methods

​Add a connection

​Profile configuration

​Schema authorization

​Profile fields reference

​Related

Optional connection attributes

Authentication methods

Add a connection

Profile configuration

Schema authorization

Profile fields reference

Related