--- title: Fabric Lakehouse - Placeholder values description: Fabric Lakehouse placeholder values name the lakehouses, schemas, source paths and connections of a Fabric Lakehouse project. --- [Skip to content](https://knowledge.bigenius-x.com/fabric-lakehouse-placeholder-values-2.0#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. [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) # Fabric Lakehouse - Placeholder values **Applies to** Platform: Fabric Lakehouse Fabric Lakehouse placeholder values name the lakehouses, schemas, source paths and connections of a Fabric Lakehouse project. Enter them in `replacement_config.json` before you run `replace_placeholders.ps1`. Afterwards the notebooks contain your names. The replacement itself is described in [Replace the placeholders in the artifacts](https://knowledge.bigenius-x.com/replace-the-placeholders-in-the-artifacts?hsLang=en). For Target Platform `Azure Synapse`, see [Azure Synapse](https://knowledge.bigenius-x.com/fabric-lakehouse-placeholder-values-2.0#azure-synapse). ### Variable names Each variable name has the form `##`, with the project name in lower case. The group is a layer, such as `stage` or `rawvault`, or a source system in lower case without spaces. Variables in the section Other variables have no project name. ### Layers and source systems #### workspace\_name The Fabric workspace of the lakehouse. Leave it empty for a lakehouse in the workspace of the notebooks; the replacement removes the empty name with its dot. #### database\_name The lakehouse of the layer. The generated file presets `datalakehouse` for every layer. For a source system, the lakehouse of the source tables, for example of a linked Stage project. #### schema\_name The schema in the lakehouse, empty in the generated file. With Generate Create Schema If Not Exists Statements selected, the default, enter a schema for every layer: an empty `schema_name` makes the deployment fail, in a lakehouse with or without schemas. The [default lakehouse](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment-2.0?hsLang=en#failure-symptoms-and-recovery) of the notebooks must then have schemas. For source tables in a lakehouse without schemas, leave it empty or enter `dbo`. #### file\_path Stage Files only: the ABFS path of the folder that holds one folder per source, ending with a slash. The loader reads ``. To copy the path, open the context menu of the **Files** folder of the lakehouse, choose **Properties** and copy **ABFS path**. Then append your folders, for example: ![Context menu of the Files folder with Properties](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Sep-05-2024-12-41-33-8402-PM.png?width=343&height=336&name=image-png-Sep-05-2024-12-41-33-8402-PM.png) ``` abfss://@onelake.dfs.fabric.microsoft.com/ .Lakehouse/Files/Parquet/ ``` Write the path on one line. #### JDBC connection Stage JDBC only: `jdbc_url`, `jdbc_driver`, `jdbc_user` and `jdbc_password`. The generated file presets SQL Server examples. The loader inserts `jdbc_user` and `jdbc_password` as Python expressions. Write a literal in single quotes, for example `''`, or read a secret from Azure Key Vault without quotes: ``` PyTridentTokenLibrary.get_secret_with_token( '', '', access_token) ``` Write it on one line. The identity that runs the notebook needs read access to the secret. A missing secret stops the loader with `404` `SecretNotFound`. ### Other variables - `loadcontrol#loadcontrol#database_name` and `schema_name`: the lakehouse and schema of the log tables; preset `datalakehouse` and empty. The rule for an empty `schema_name` above applies here too. - `execution_log_table_name` and `deployment_log_table_name`: preset `execution_log` and `deployment_log`. - `application_name` and `application_environment_name`: written to every log row; preset empty and `DEV`. - `deployment_objects_timeout` and `deployment_loadcontrol_timeout`: seconds for the deployment and the load control deployment; preset `3600` and `120`. - `run_notebook_timeout`: seconds each loader notebook may run in the native load control; preset `3600`. - `airflow#airflow#fabric_conn_id`: the Airflow connection of the DAG; preset `fabric-integration`. Give each project its own load control lakehouse or schema (placeholders `loadcontrol#loadcontrol#database_name` and `schema_name`). With the default Deployment Options, a project that deploys the load control into the same location replaces the logs of the other projects. ### Example A DataVault and Mart project `test.vaultandmart.spark.fabric` deploys its Stage to the lakehouse `my_lakehouse`, which has schemas, with the example schema `stage`: ``` { "name": "test.vaultandmart.spark.fabric#stage#workspace_name", "value": "", "secretname": "" }, { "name": "test.vaultandmart.spark.fabric#stage#database_name", "value": "my_lakehouse", "secretname": "" }, { "name": "test.vaultandmart.spark.fabric#stage#schema_name", "value": "stage", "secretname": "" } ``` After the replacement, the Stage table is ``my_lakehouse`.`stage`.`stg_st_item``. Example files: [Stage Files](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/replacement_config_Fabric_Lakehouse_StageFiles_2.0.json), [Stage JDBC](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/replacement_config_Fabric_Lakehouse_JDBC_2.4.json), [Data Store](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/replacement_config_Fabric_Lakehouse_DataStore_2.0.json), [Dimensional and Mart](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/replacement_config_Fabric_Lakehouse_DIMDM_2.0.json), [DataVault and Mart](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/replacement_config_Fabric_Lakehouse_DVDM_2.0.json). ### Azure Synapse With Target Platform `Azure Synapse`, the layers and the load control are databases in a storage account, without `workspace_name`. These values differ: - `database_name`: the database of the layer, preset with the layer name, for example `rawvault`. For a source system, the database that holds the source tables. - `database_directory`: the storage path of the database, ending with a slash, for example `abfss://@.dfs.core.windows.net/rawvault/`. The notebooks run `CREATE DATABASE IF NOT EXISTS ... LOCATION` with it. - `schema_name`: leave it empty for the layers; the replacement removes it with its dot. In a Stage JDBC project, enter the schema of the source tables for the source system. - `loadcontrol#loadcontrol#database_name` and `database_directory`: empty in the generated file. Enter a database name and a path. - `file_path`: the storage path of the source folders, in the same form. - `jdbc_user` and `jdbc_password`: a literal in single quotes. - `datafactory_pipeline#datafactory_pipeline#` variables: settings of the [pipelines for Apache Airflow](https://knowledge.bigenius-x.com/fabric-lakehouse-load-data-apache-airflow-load-control?hsLang=en#azure-synapse). Example files: [Stage Files](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/replacement_config_Azure_Synapse_StageFiles_2.0.json), [Stage JDBC](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/replacement_config_Azure_Synapse_JDBC_2.4.json), [Data Store](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/replacement_config_Azure_Synapse_DataStore_2.0.json), [Dimensional and Mart](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/replacement_config_Azure_Synapse_DIMDM_2.0.json), [DataVault and Mart](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/replacement_config_Azure_Synapse_DVDM_2.0.json). ### Release differences - Generator 2.2: `airflow#airflow#fabric_conn_id` and the `datafactory_pipeline` variables, with LoadControl Options `Airflow`. - Generator 2.0: with Target Platform `Fabric`, `database_name` is preset with `datalakehouse`. #### Legacy placeholders Up to Generator 1.10, Fabric projects also had `database_directory`, which you left empty. Generator 1.9 had `log_table_name`; since Generator 1.10 it is `execution_log_table_name` and `deployment_log_table_name`. Generator 1.8 had `execution_dependencies_file_path`. ### Related articles - Previous: [Fabric Lakehouse - Target environment](https://knowledge.bigenius-x.com/fabric-lakehouse-target-environment?hsLang=en), [Azure Synapse - Target environment](https://knowledge.bigenius-x.com/azure-synapse-target-environment?hsLang=en), [Download generated artifacts](https://knowledge.bigenius-x.com/download-generated-artifacts?hsLang=en) - Next: [Fabric Lakehouse - Deployment](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment-2.0?hsLang=en), [Azure Synapse - Deployment](https://knowledge.bigenius-x.com/azure-synapse-deployment-2.0?hsLang=en) - See also: [Replace the placeholders in the artifacts](https://knowledge.bigenius-x.com/replace-the-placeholders-in-the-artifacts?hsLang=en), [Fabric Lakehouse - Artifacts](https://knowledge.bigenius-x.com/fabric-lakehouse-artifacts-2.0?hsLang=en), [Fabric Lakehouse - Load data - Native Load Control](https://knowledge.bigenius-x.com/fabric-lakehouse-load-data-native-load-control-2.0?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) All rights reserved © 2025, biGENIUS AG