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.3 Loading Unstructured Data to HeatWave Lakehouse

5.4 Editing Loaded Data

5.4.1 Lakehouse Incremental Load

5.4.2 Editing Loaded Data Using ALTER TABLE and Engine Attribute

5.5 Access Object Storage

5.5.1 Pre-Authenticated Requests

5.5.2 Resource Principals

5.6 External Table Recovery

5.7 Data Types

5.7.1 Parquet Data Type Conversions

5.8 Exporting Query Results to Object Storage

5.9 HeatWave Lakehouse Error Messages

5.10 HeatWave Lakehouse Limitations

5.10.1 Lakehouse Limitations for all File Formats

5.10.2 Lakehouse Limitations for the Avro Format Files

5.10.3 Lakehouse Limitations for the CSV File Format

5.10.4 Lakehouse Limitations for the JSON File Format

5.10.5 Lakehouse Limitations for the Parquet File Format

This chapter describes HeatWave Lakehouse.