Native - Load control environment
Applies to
Platform: Microsoft SQL Server · Snowflake · Databricks · Fabric Lakehouse · Fabric Warehouse · Oracle
A native load control runs the loaders inside the target platform, without another tool. Choose it with the native value of LoadControl Options. The environment you need is the target platform itself.
The dbt generators have no native load control.
What runs where
- Microsoft SQL Server and Oracle (
Native Load Control): tables and stored procedures in a load-control schema of the target database. The deployment creates and configures them; you run the generated execution script. - Databricks, Fabric Lakehouse and Fabric Warehouse (
Multi-Threading Notebook): a load-control notebook runs the loader notebooks on four threads in dependency order. - Snowflake (
Depending Tasks,Stage-Driven Tasks,Near-Realtime Tasks): Snowflake tasks run the loaders.
The target environment of each platform is described under Target solution environment. The steps to load data are under Load data with a native load control.
Related articles
- Next: Load data with a native load control
- Reference: LoadControl Options (Project)
- See also: Understand Load Control, Apache Airflow - Load control environment