---
title: Databricks Unity - Placeholder values - 1.8
description: Please consult the article Replace the placeholders in the Artifacts to learn how to replace the placeholders with the values explained below.
---

[Skip to content](https://knowledge.bigenius-x.com/databricks-unity-placeholder-values-1.8#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)

# Databricks Unity - Placeholder values - 1.8

Please consult the article [Replace the placeholders in the Artifacts](https://knowledge.bigenius-x.com/replace-the-placeholders-in-the-artifacts?hsLang=en) to learn how to replace the placeholders with the values explained below.

### Placeholder values

Depending on the Generator Configuration you are using for a Databricks Unity Target Technology, you can replace the placeholder values with the following:

#### database\_name

Each ***database\_name* placeholder** should contain the database name in your Unity Catalog.

If you are using a **Linked Project** (from a Stage JDBC or a Stage File Project), it should contain the **database name of the source table** created before with the Linked Project in your Unity Catalog.

#### database\_directory

Each ***database\_directory* placeholder** should contain the **path to create** the **Target Parquet files**.

If you are using our [Databricks environment](https://knowledge.bigenius-x.com/databricks-target-environment?hsLang=en) example, the path is the one inside the Storage Account chosen to store the Target Data Lake  
*abfss://docu-datalake@bgdatabricksdatalake1.dfs.core.windows.net/rawvault/* forthe Raw Vault layer placeholder  
*docu-datalake* is the name of the folder we created inside the Storage Account  
*bgdatabricksdatalake1* is the name of the Storage Account itself

All the **paths** should have a **slash appended at the end**: *abfss://docu-datalake@bgdatabricksdatalake1.dfs.core.windows.net/rawvault/*

#### schema\_name

Each ***schema\_name* placeholder** should contain the schema name in your Unity Catalog

In our example, it is *docu\_rawvault, docu\_businessvault* and *docu\_mart.*

If you are using a **Linked Project** (from a Stage JDBC or a Stage File Project), itshould contain the schema name **of the source table** created before with the Linked Project in your Unity Catalog. 

In our example, it is *docu\_stage*

#### execution\_dependencies\_file\_path

If you plan to use a **[native loaded control using multi-threading load](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)**, please update the ***execution\_dependencies\_file\_path* placeholder **with the Databricks path that contains the generated dependencies file *XXXX\_dependencies.json*  
In our example, it is ***file:**/Workspace/Users/\[UserName\]/StageFile/bg\_databricksunitystagefiles\_dependencies.json*

It corresponds to the full path of the file in Databricks prefixed by "file:"

#### file\_path

Each ***file\_path* placeholder** should contain the **path** where the **Source Parquet files** are available.

Suppose you are using our [Databricks environment](https://knowledge.bigenius-x.com/databricks-stage-files-target-environment?hsLang=en) example. In that case, the path is the one inside the Storage Account chosen to store the Source Parquet files  
*abfss://source@bgdatabrickslandingzone1.dfs.core.windows.net/adventureworks* 

- *source* is the name of the folder we created inside the Storage Account
- *bgdatabrickslandingzone1* is the name of the Storage Account itself
- *adventureworks *is the name of the subfolder we created inside the *source* folder

It would be best to use the same path for all the file\_path placeholders. Each Parquet source file is stored in an uppercase folder with the same name. This folder name will be generated automatically. Please don't use it in the placeholder replacement.

All the **paths** should have a **slash appended at the end**: *abfss://docu-datalake@bgdatabricksdatalake1.dfs.core.windows.net/stage/*

#### jdbc\_url

For a SQL Server JDBC source, for example: *jdbc:sqlserver://**{ServerName}**.database.windows.net:1433;encrypt=true;databaseName=**{DatabaseName}**;trustServerCertificate=true;*

Replace:

- *{ServerName} with your Azure SQL Server name*
- *{DatabaseName}* with your SQL Server database name.

#### jdbc\_driver

For a SQL Server JDBC source, for example:

*com.microsoft.sqlserver.jdbc.SQLServerDriver*

#### jdbc\_user

For a SQL Server JDBC source, for example:

'***{DatabaseUser}***'

Replace *{DatabaseUser}* with your SQL Server user.

Putting the user inside quotes ***'user\_name'***  is essential**.**

Or you can use KeyVault to store a secret.

In this case, the syntax should be:  
*dbutils.secrets.get(scope='jdbc', key='\<name of the secret\>') *

#### jdbc\_password

For a SQL Server JDBC source, for example:

'***{DatabasePassword}***'

Replace *{DatabasePassword}* with your SQL Server password

Putting the password inside quotes ***'password'***  is essential**.**

#### user\_name

If you are using [**Airflow**](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow) as a Load Control environment, ***databricks\_job#databricks\_job#user\_name*** must be your databricks user name.

#### notebook\_task\_path

If you are using **[Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow)** as a Load Control environment, ***databricks\_job#databricks\_job#notebook\_task\_path*** must be the location of the Jupyter Notebooks into Databricks.

In our example: /Workspace/Users/\<username\>/Artifacts\_DVDM/

#### existing\_cluster\_id

If you are using [**Airflow**](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow) as a Load Control environment ***databricks\_job#databricks\_job#existing\_cluster\_id*** must be the ID of the cluster to use.

To find it:

- Open Databricks
- Click on the **Compute** menu on the left-hand-side:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-19-2023-12-39-29-4012-PM.png?width=147&height=43&name=image-png-Oct-19-2023-12-39-29-4012-PM.png)
- Open the Cluster created in your Databricks environment
- Click on the **More ...** button:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Aug-08-2024-01-08-28-9765-PM.png?width=111&height=57&name=image-png-Aug-08-2024-01-08-28-9765-PM.png)
- Select the **View JSON** option
- The Cluster ID is available on the top of the JSON:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Aug-08-2024-01-09-41-9726-PM.png?width=433&height=231&name=image-png-Aug-08-2024-01-09-41-9726-PM.png)

 

 

- [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)
    - [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