From the course: Oracle HeatWave MySQL Foundations

Unlock this course with a free trial

Join today to access over 24,000 courses taught by industry experts.

Loading data using Auto Parallel Load

Loading data using Auto Parallel Load

From the course: Oracle HeatWave MySQL Foundations

Start my 1-month free trial Buy for my team

Loading data using Auto Parallel Load

“

(gentle music) - [Lecturer] Welcome to this lesson on loading data using Auto Parallel Load. It explains how to invoke Auto Parallel Load with various options and view the generated report. Auto Parallel Load automates the steps of loading data into HeatWave. It excludes tables and columns that cannot be loaded, such as columns with unsupported data types or tables with too many columns. It defines the RAPID secondary engine for tables that are to be loaded. It verifies that there is sufficient memory available for the loaded data. It optimizes the load parallelism based on machine learning models. And it loads the data into HeatWave and generates a report. To initiate Auto Parallel Load, you just need to run one command to invoke a stored procedure and provide a list of schemas that you want to load. Auto Parallel Load has additional requirements in addition to the requirements of loading data into HeatWave. The user must have the following MySQL privileges: The PROCESS privilege…

Contents