Fabric Warehouse - Target environment
Applies to
Platform: Fabric Warehouse
Prepare a Fabric workspace for a Fabric Warehouse project: a warehouse, a lakehouse for the execution log and a Key Vault with service principal secrets. Afterwards you can deploy and load the generated artifacts. The setup applies to all Fabric Warehouse generator configurations, including Dimensional and Dimensional and Mart.
This article shows one possible setup. Microsoft Fabric and Azure Key Vault offer many other configurations, which their documentation describes.
Prerequisites
- Access to Microsoft Fabric with a capacity on which you can create a workspace, a warehouse and lakehouses.
- A service principal, an application in Microsoft Entra ID, with a client secret.
- An Azure subscription in which you can create a Key Vault.
Set up the environment
Store the secrets in a Key Vault
- Create a Key Vault, as described in the Azure Key Vault quickstart.
- Add the secret
client-idwith the client ID of the service principal. Azure shows it as Application ID in Enterprise applications.
- Add the secret
client-secretwith a client secret of the application. - Add the secret
tenant-idwith the tenant ID. Fabric shows it when you select your profile picture and point to the information icon next to the tenant name.
The secret names are examples; you enter them as placeholder values. The load notebook reads the secrets with the identity of the user who runs it, so that user needs read access to them.
Create the workspace
- In Fabric, select Workspaces, then New workspace.

- Enter a name, for example
bgDocumentationWarehouse, and select Apply.
- Select Manage access, then Add people or groups. Search for the service principal, choose the role Member and select Add.

The service principal is now listed as a Member of the workspace. The Member role is sufficient for deploy.ps1 and for the connections of the load notebook.

Create the warehouse and the lakehouse
- In the workspace, select New item, then Warehouse.

- Enter a name, for example
docu_bgwarehouse, and create the warehouse. - Select New item, then Lakehouse, and create a lakehouse for the execution log, with or without Lakehouse schemas.

deploy.ps1 needs at least one warehouse and one lakehouse in the workspace. An execution log in a lakehouse with schemas needs a default lakehouse with schemas, see Fabric Warehouse - Placeholder values. If the default lakehouse that deploy.ps1 sets for the load control notebooks has no schemas, make a lakehouse with schemas their default lakehouse.
To keep the notebooks in Git, connect the workspace in its workspace settings under Git integration, as the Microsoft Fabric documentation describes.
Provide source data from a lakehouse
The Stage reads its source tables through the warehouse, with the source system type Microsoft Fabric Warehouse. To read tables of another lakehouse, create a lakehouse with shortcuts to them in the workspace of the warehouse:
- Select New item, then Lakehouse. Enter a name, for example
lakehouse_shortcut, and select Create.
- In the Tables folder, open the context menu and choose New shortcut.

- Select Microsoft OneLake.

- Select the lakehouse that holds the source data and select Next.

- Select the source tables, then select Next and Create.

The shortcuts appear in the Tables folder:

The warehouse finds the shortcut tables only after the SQL analytics endpoint of the lakehouse has synchronized its metadata; until then, a query on them fails with Invalid object name.
In the placeholder values, enter the lakehouse name as database_name of the source system and dbo as schema_name for a lakehouse without schemas.
Projects of the other Fabric Warehouse configurations can also read the model objects of a linked project. Fabric Warehouse Stage offers no linked project import.
Check the result
The workspace contains the warehouse and at least one lakehouse, and Manage access lists the service principal as Member. The Key Vault holds the three secrets.
Upload artifacts in Microsoft Fabric
Uploading and running the generated notebooks is described in Fabric Warehouse - Deployment.
Failure symptoms and recovery
Failures of the deployment, such as a missing warehouse or lakehouse, are described in Fabric Warehouse - Deployment. Load failures are described in Fabric Warehouse - Load data - Native Load Control.
Related articles
- Next: Generate artifacts, Replace the placeholders in the artifacts, Fabric Warehouse - Deployment
- Reference: Fabric Warehouse - Placeholder values
- See also: Fabric Warehouse Stage, Fabric Warehouse Data Store, Fabric Warehouse Data Vault, Fabric Warehouse Data Mart, Fabric Warehouse Data Vault and Mart, Fabric Warehouse Dimensional, Fabric Warehouse Dimensional and Mart, Use Linked Projects