Chapter 5 HeatWave Lakehouse

Table of Contents

5.1 Overview

5.1.1 External Tables

5.1.2 Lakehouse Engine

5.1.3 Data Storage

5.2 Loading Structured Data to HeatWave Lakehouse

5.2.1 System Requirements

5.2.2 Lakehouse External Table Syntax

5.2.3 Loading Data Manually

5.2.4 Loading Data Using Auto Parallel Load

5.2.5 How to Load Data from External Storage Using Auto Parallel Load

5.2.6 Lakehouse Incremental Load

5.3 Loading Unstructured Data to HeatWave Lakehouse

5.4 Access Object Storage

5.4.1 Pre-Authenticated Requests

5.4.2 Resource Principals

5.5 External Table Recovery

5.6 Data Types

5.6.1 Parquet Data Type Conversions

5.7 HeatWave Lakehouse Error Messages

5.8 HeatWave Lakehouse Limitations

5.8.1 Lakehouse Limitations for all File Formats

5.8.2 Lakehouse Limitations for the Avro Format Files

5.8.3 Lakehouse Limitations for the CSV File Format

5.8.4 Lakehouse Limitations for the JSON File Format

5.8.5 Lakehouse Limitations for the Parquet File Format

This chapter describes HeatWave Lakehouse.