HeatWave Release Notes
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_ATTRIBUTEoptions of theCREATE TABLEstatement to specify the parameters needed to process data stored externally in Object Storage. The external tableENGINE_ATTRIBUTEis aJSONobject that consists of the dialect parameters and the file parameters. Review Lakehouse External Table JSON Syntax.