4.3.6 Lakehouse External Table 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.