LoadControl Options (Project)

Description

The LoadControl Options Property is available in Project Settings.

You can select how the loads will be orchestrated.

Format

The LoadControl Options is a List of multiple values.

It is possible to select several values.

The possible values are:

• Native Load Control:
  • The data load will be orchestrated with a Load Control in the target technology
  • More details: Load data with a native load control.

• Multi-Threading Notebook:
  • The data load will be orchestrated with a Load Control in the target technology
  • The orchestration will use multiple threads
  • More details: Load data with a native load control.

• Sequential Notebook:
  • The data load will be orchestrated with a Load Control in the target technology
  • The orchestration will use a single-thread
  • More details: Load data with a native load control.

• Depending Tasks:
  • The data load will be orchestrated with a Load Control in the target technology
  • The orchestration will use Snowflake Tasks 
  • More details: Load data with a native load control.

• Near-realtime Tasks:
  • The data load will be orchestrated with a Load Control in the target technology
  • The orchestration will use Snowflake Dynamic Tables with Stream
  • More details: Load data with a native load control.

• Stage-Driven Tasks:
  • The data load will be orchestrated with a Load Control in the target technology
  • A load plan by Stage Model Object will be created.
  • More details: Load data with a native load control.

• Airflow:
  • The data load will be orchestrated with Apache Airflow
  • More details: Load data with Apache Airflow.

Example:

Default Value

The default value depends on the target technology:

• Microsoft SQL Server: Native Load Control
• Microsoft Fabric and Databricks: Multi-Threading Notebook
• Snowflake: Depending Tasks