generate_dbt_profile
Generate dbt project files for Fabric Data Warehouse, including profiles, project config, sources, and dependencies. Handles authentication via Entra ID without exposing secrets.
Instructions
Generate dbt-fabric project file contents for a Fabric Data Warehouse.
Returns the generated file contents as text strings. Because the MCP server cannot write to the caller's local filesystem, it is the caller's responsibility to write the returned strings to the appropriate files.
Authentication note: dbt-fabric is Entra-only. ServicePrincipal mode emits
{{ env_var(...) }} placeholders for tenant_id / client_id / client_secret
— no literal secrets are included in the output.
Args:
workspace: Workspace name or GUID.
item: Warehouse name or GUID.
project_name: dbt project name (default: sanitized warehouse name).
profile_name: dbt profile name (default: same as project_name).
schema: Default schema (default: dbo).
target: dbt output target name (default: dev).
threads: Number of dbt threads (default: 4).
authentication: dbt-fabric authentication string —
auto (DefaultAzureCredential), CLI (interactive),
or ServicePrincipal. Defaults to the server's auth mode.
with_sources: When True, generate a _sources.yml from the
warehouse's actual schemas and tables.
Returns:
A dict with keys:
- profiles_yml: content for profiles.yml.
- dbt_project_yml: content for dbt_project.yml.
- sources_yml: content for models/staging/_sources.yml.
- requirements_txt: content for requirements.txt.
- gitignore: content for .gitignore.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workspace | Yes | ||
| item | Yes | ||
| project_name | No | ||
| profile_name | No | ||
| schema | No | dbo | |
| target | No | dev | |
| threads | No | ||
| authentication | No | ||
| with_sources | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||