4.3.6 Lakehouse External Table Syntax

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

As of MySQL 9.4.0, you can use SQL syntax to set table-level and column-level options for external tables. Review Lakehouse External Table SQL Syntax.
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.