4.3.6 Lakehouse External Table Syntax

4.3.6.1 Lakehouse External Table JSON Syntax

4.3.6.2 Lakehouse External Table SQL Syntax

To set options when creating external tables, you have the following options:

• You can use table-level and column-level ENGINE_ATTRIBUTE options of the CREATE TABLE statement to specify the parameters needed to process data stored externally in Object Storage. The external table ENGINE_ATTRIBUTE is a JSON object that consists of the dialect parameters and the file parameters. Review Lakehouse External Table JSON Syntax.

• As of MySQL 9.4.0, you can use the SQL syntax to set table-level and column-level options for external tables. Review Lakehouse External Table SQL Syntax.