Microsoft Fabric
Microsoft Fabric is a unified analytics platform that combines data warehousing and analytics services. As a development environment in Paradime, Microsoft Fabric enables dbt™️ development from Paradime's Code IDE.
IP RESTRICTIONS
Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.
👉 See also: Paradime IP addresses.
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 PasswordServicePrincipal
- Service Principal Authentication
Setup Instructions
Click the gear Icon (⚙️) on the top right of the Paradime interface to access Account Settings
In the left sidebar, click "Connections"
Click "Add New" next to the Code IDE section
Select "Microsoft Fabric"
In the Profile Configuration field, add the following parameters based on your authentication method. Reference the Profile Fields Reference section below for additional context and configurations:
After adding the configuration, ensure it's properly formatted using a YAML formatter like YAML Formatter.
Provide a dbt™ Profile Name (This should match with the profile name set in your
dbt_project.yml
).In the Target field, enter "dev". This is the default target your dbt project will use for development work.
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 number to specify how many parallel operations your dbt project can run.
Example Profile Configuration
Schema Authorization
When creating schemas in Microsoft Fabric, you can control who owns them. Here's what you need to know:
Schema ownership is defined using the AUTHORIZATION Argument. The syntax follows this pattern:
Useful for managing permissions in Microsoft Entra ID environments
Recommended when working with group-based permissions
Profile Fields Reference
driver
OBDC 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. This is configured in the UI "Schema" field
dbo
dbo
✅
authentication
Authentication method
sql
sql
✅
retries
Number of connections 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
❌
Last updated