---
title: Databricks Unity - Load data - Native Load Control - 1.8
description: Databricks Unity - Load data - Native Load Control - 1.8
---

[Skip to content](https://knowledge.bigenius-x.com/databricks-unity-load-data-native-load-control-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. [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)

# Databricks Unity - Load data - Native Load Control - 1.8

Before loading the data from your Source(s) System(s) to your Databricks Unity Target System, please:

- [Deploy the generated Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment)

You are now ready to load the data.

There are two possibilities to **load the data natively** with Databricks Unity Catalog:

- Sequentially on a single thread
- In parallel with a multi-thread approach

You can also load the data with an external tool as:

- [Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow)

### Load the data

We will explain how to load the data using the [possible target environment Databricks Unity](https://knowledge.bigenius-x.com/databricks-unity-target-environment?hsLang=en).

To load the data:

- Open **Databricks** with the URL provided in the Azure Databricks Service resource:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Sep-09-2024-09-12-53-6145-AM.png?width=688&height=171&name=image-png-Sep-09-2024-09-12-53-6145-AM.png)
- Databricks is opened:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Sep-09-2024-09-13-00-1678-AM.png?width=688&height=218&name=image-png-Sep-09-2024-09-13-00-1678-AM.png)
- Click on the Workspace menu on the left-hand-side:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Sep-09-2024-09-13-06-7269-AM.png?width=171&height=44&name=image-png-Sep-09-2024-09-13-06-7269-AM.png)
- Expand the folders Workspace \> Users \> *Your\_user* \> artifacts:  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Sep-09-2024-09-14-04-5538-AM.png?width=256&height=263&name=image-png-Sep-09-2024-09-14-04-5538-AM.png)
- Open the ***500\_Deploy\_and\_Load\_DataVault\_Databricks.ipynb*** file, which contains three steps:  
    1. *%run ./XXX\_Deployment.ipynb*: Deploy the code
    2. *%run ./XXX\_SimpleLoadExecution.ipynb*: Load the data sequentially in a single thread
    3. *%run ./XXX\_MultithreadingLoadExecution:* Load the data in parallel with a multi-thread approach
    4. *%run ./XXX\_SelectResults.ipynb*: Display the results
- Execute **(steps 2 or step 3), then step 4**
- Select the Personal Compute created during the target environment setup:  
  **![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Sep-09-2024-09-25-23-5136-AM.png?width=688&height=264&name=image-png-Sep-09-2024-09-25-23-5136-AM.png)**
- Click on the **Attach and run** button:  
  **![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Sep-09-2024-09-26-02-0537-AM.png?width=160&height=56&name=image-png-Sep-09-2024-09-26-02-0537-AM.png)**
- The data were loaded: 
    - You should have the **target Parquet files created** for each Target Model Object, for example, for the Stage CreditCard:  
      ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Sep-09-2024-09-41-52-5840-AM.png?width=688&height=139&name=image-png-Sep-09-2024-09-41-52-5840-AM.png)
    - Step 3 displayed a resume of the number of rows loaded for each Target Model  Object, for example:![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-19-2023-01-33-46-1065-PM.png?width=688&height=402&name=image-png-Oct-19-2023-01-33-46-1065-PM.png)

You can now check that your data were correctly loaded with the following script:

```
%sqlselect * from `rawvault`.`rdv_hub_creditcard_hub`;
```

And see the content of your Target Parquet file:

![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-19-2023-01-35-08-2161-PM.png?width=688&height=167&name=image-png-Oct-19-2023-01-35-08-2161-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