Skip to Main Content
Analyze data at scale in object storage with MySQL HeatWave Lakehouse

About This Workshop

Youtube Video

About This Workshop
In this workshop, you will learn how to process and query hundreds of terabytes of data in the object store—in a variety of file formats using MySQL HeatWave Lakehouse. Understand how to load various file formats and run query processing with standard SQL syntax without the data having to leave the object store. See the MySQL autopilot capabilities that make it simple to use.

Workshop Info

1 hour, 30 minutes
  1. Create Compartment, VCN, and MySQL HeatWave Database
  2. Create Compute with MySQL Shell
  3. Upload data to Object Storage for HeatWave Lakehouse
  4. Setup HeatWave with mysql_customer_orders Data
  5. Load data into HeatWave Cluster
  6. Load CSV data from OCI Object Store
  7. Load Parquet format data directly from Object Store
  8. (Bonus) Develop MySQL HeatWave Apps with LAMP
  9. Stop OCI Services

     
  • Familiarity with MySQL Database is desirable, but not required
  • Some understanding of cloud and database terms is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful

Other Workshops you might like