4.4 Loading Data Using Auto Parallel Load

4.4.1 Lakehouse Auto Parallel Load Schema Inference

4.4.2 Lakehouse Auto Parallel Load

4.4.3 Loading Data from External Storage Using Auto Parallel Load

HeatWave Lakehouse extends Auto Parallel Load in two ways:

• Lakehouse Auto Parallel Load includes schema inference which analyzes the external data to infer the table structure.

• Lakehouse Auto Parallel Load uses the external_tables option to enable loading data from external sources.

Lakehouse Auto Parallel Load facilitates the process of loading data into HeatWave by automating many of the steps involved, including:

• All these steps: Section 2.2.3, “Loading Data Using Auto Parallel Load”.

• Defining lakehouse as the engine for tables that are to be loaded.

• Defining the ENGINE_ATTRIBUTE for tables that are to be loaded.