---
title: Fabric Lakehouse - Target environment
description: "Prepare a Microsoft Fabric workspace for a Fabric Lakehouse project: a lakehouse with schemas, a service principal for the deployment and the source data."
---

[Skip to content](https://knowledge.bigenius-x.com/fabric-lakehouse-target-environment#main-content)

[Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en)

[![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/)

Open main navigation

Close main navigation

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new)
- [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en)
2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en)
3. [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment)

# Fabric Lakehouse - Target environment

**Applies to**  
Platform: Fabric Lakehouse

Prepare a Microsoft Fabric workspace for a Fabric Lakehouse project: a lakehouse with schemas, a service principal for the deployment and the source data. Afterwards you can deploy and load the generated artifacts. The setup applies to all Fabric Lakehouse generator configurations with the project property [Target Platform](https://knowledge.bigenius-x.com/target-platform-project?hsLang=en) set to `Fabric`, the default.

This article shows one possible setup. Microsoft Fabric offers many other configurations, which its documentation describes. For Target Platform `Azure Synapse`, see [Azure Synapse - Target environment](https://knowledge.bigenius-x.com/azure-synapse-target-environment?hsLang=en).

### Prerequisites

- Access to Microsoft Fabric with a capacity on which you can create a workspace and lakehouses.
- A service principal, an application in Microsoft Entra ID, with a client secret.

### Set up the environment

#### Create the workspace

1. In Fabric, select **Workspaces**, then **New workspace**.  
   ![Workspaces panel in Fabric with the New workspace button](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-18-2025-01-57-36-3020-PM.png?width=213&height=340&name=image-png-Mar-18-2025-01-57-36-3020-PM.png)
2. Enter a name, for example `bgDocumentation`, and select **Apply**.  
   ![Create a workspace dialog with the name bgDocumentation](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-25-2026-08-31-12-6596-AM.png?width=357&height=352&name=image-png-Mar-25-2026-08-31-12-6596-AM.png)
3. Select **Manage access**, then **Add people or groups**. Search for the service principal, choose the role **Member** and select **Add**.  
   ![Add people dialog with the role Member](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-16-2026-09-12-52-6775-AM.png?width=250&height=195&name=image-png-Mar-16-2026-09-12-52-6775-AM.png)

The Member role is sufficient for `deploy.ps1`. To keep the notebooks in Git, connect the workspace in its workspace settings under Git integration, as the Microsoft Fabric documentation describes.

#### Create the lakehouse

1. In the workspace, select **New item**, then **Lakehouse**.  
   ![Lakehouse item type](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-09-2026-09-37-36-7837-AM.png?width=217&height=33&name=image-png-Mar-09-2026-09-37-36-7837-AM.png)
2. Enter a name, for example `bg_lakehouse_doc`, select **Lakehouse schemas** and create the lakehouse.

The deployment creates a schema for each layer and one for the load control, with the names of the [placeholder values](https://knowledge.bigenius-x.com/fabric-lakehouse-placeholder-values-2.0?hsLang=en). `deploy.ps1` needs at least one lakehouse in the workspace. It sets the first lakehouse it finds as the default lakehouse of every notebook. Targets in a lakehouse with schemas need a default lakehouse with schemas, see [Fabric Lakehouse - Deployment](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment-2.0?hsLang=en#failure-symptoms-and-recovery).

### Provide source data

A Fabric Lakehouse project gets its source data in one of three ways:

- Delta or Parquet files in OneLake, discovered directly in the project, see [Discover Parquet or Delta files on OneLake](https://knowledge.bigenius-x.com/discover-parquet-or-delta-files-on-onelake?hsLang=en).
- Files loaded by a Fabric Lakehouse - Stage Files project, imported as a [linked project](https://knowledge.bigenius-x.com/manage-linked-projects?hsLang=en).
- Database tables loaded over JDBC by a Fabric Lakehouse - Stage JDBC project, imported as a linked project.

#### Files

Upload the source files into the **Files** folder of a lakehouse. In the context menu of the folder, choose **Upload**, then **Upload folder**.

![Context menu of the Files folder with Upload and Upload folder](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-25-2026-08-40-56-6793-AM.png?width=440&height=394&name=image-png-Mar-25-2026-08-40-56-6793-AM.png)

The Stage loader reads the folder `<file_path><source name>`, where `<source name>` is the name of the source model object. Put each source in its own folder with that name, for example `Files/Parquet/CreditCard/CreditCard.parquet` for the source `CreditCard`:

![Files folder Parquet with one folder per source, the folder CreditCard holding CreditCard.parquet](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-25-2026-08-44-19-0062-AM.png?width=670&height=300&name=image-png-Mar-25-2026-08-44-19-0062-AM.png)

A Delta source is a folder with the Delta table, named the same way:

![Folder of a Delta source with its Delta files](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-25-2026-08-44-47-0480-AM.png?width=670&height=206&name=image-png-Mar-25-2026-08-44-47-0480-AM.png)

The path up to the source folders is the placeholder value `file_path`.

#### Database

A Stage JDBC project reads tables of a database such as Microsoft SQL Server or PostgreSQL. The notebooks must reach the database from Fabric. For an Azure SQL Database, select **Allow Azure services and resources to access this server** in the networking settings of the server:

![Server networking setting Allow Azure services and resources to access this server, selected](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Feb-22-2024-08-57-29-5471-AM.png?width=389&height=77&name=image-png-Feb-22-2024-08-57-29-5471-AM.png)

### Check the result

The workspace contains the lakehouse with schemas, and **Manage access** lists the service principal as Member:

![Manage access with the service principal as Member](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-16-2026-09-14-31-2812-AM.png?width=227&height=206&name=image-png-Mar-16-2026-09-14-31-2812-AM.png)

After the first deployment, the explorer of the lakehouse shows the schemas below **Tables**:

![Lakehouse bg\_lakehouse\_doc with the schemas dbo, DataStore, DIM\_Core, DV\_RDV, LoadControl, StageFiles, StageJDBC and others below Tables](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-25-2026-09-59-43-9496-AM.png?width=224&height=468&name=image-png-Mar-25-2026-09-59-43-9496-AM.png)

### Upload artifacts in Microsoft Fabric

Uploading and running the generated notebooks with `deploy.ps1` is described in [Fabric Lakehouse - Deployment](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment-2.0?hsLang=en).

### Failure symptoms and recovery

Failures of the deployment, such as a default lakehouse without schemas, are described in [Fabric Lakehouse - Deployment](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment-2.0?hsLang=en#failure-symptoms-and-recovery). Load failures are described in [Fabric Lakehouse - Load data - Native Load Control](https://knowledge.bigenius-x.com/fabric-lakehouse-load-data-native-load-control-2.0?hsLang=en#failure-symptoms-and-recovery).

### Related articles

- Next: [Generate artifacts](https://knowledge.bigenius-x.com/generate-artifacts?hsLang=en), [Replace the placeholders in the artifacts](https://knowledge.bigenius-x.com/replace-the-placeholders-in-the-artifacts?hsLang=en), [Fabric Lakehouse - Deployment](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment-2.0?hsLang=en)
- Reference: [Fabric Lakehouse - Placeholder values](https://knowledge.bigenius-x.com/fabric-lakehouse-placeholder-values-2.0?hsLang=en), [Target Platform (Project)](https://knowledge.bigenius-x.com/target-platform-project?hsLang=en)
- See also: [Fabric Lakehouse - Stage Files](https://knowledge.bigenius-x.com/fabric-lakehouse-stage-files-2.0?hsLang=en), [Fabric Lakehouse - Stage JDBC](https://knowledge.bigenius-x.com/fabric-lakehouse-stage-jdbc-2.0?hsLang=en), [Discover Parquet or Delta files on OneLake](https://knowledge.bigenius-x.com/discover-parquet-or-delta-files-on-onelake?hsLang=en), [Manage Linked Projects](https://knowledge.bigenius-x.com/manage-linked-projects?hsLang=en), [Azure Synapse - Target environment](https://knowledge.bigenius-x.com/azure-synapse-target-environment?hsLang=en)

- [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content)

    - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines)
    - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working)
    - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account)
- [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en)
- [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en)
- [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content)

    - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration)
    - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions)
    - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features)
    - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects)
    - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches)
    - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections)
    - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview)
    - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps)
    - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms)
    - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping)
    - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships)
    - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality)
    - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes)
    - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling)
    - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts)
    - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings)
    - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace)
- [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content)

    - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse)
    - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse)
    - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks)
    - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake)
    - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server)
    - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle)
    - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts)
    - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders)
    - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment)
    - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment)
    - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline)
    - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment)
    - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment)
    - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)
    - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow)
    - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type)
    - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties)
    - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms)
- [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content)

    - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations)
- [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content)

    - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches)
    - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases)
    - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules)
    - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules)
- [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en)
- [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content)

    - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application)
    - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application)
    - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators)
- [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content)

    - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs)
    - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits)

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en)
- [Customer Portal](https://knowledge.bigenius-x.com/customer-portal)
- [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login)

[![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com)

<https://www.linkedin.com/company/bigenius> <https://www.youtube.com/@biGENIUS_DWA>

All rights reserved © 2025, biGENIUS AG