5.1.1 External Tables

External tables are non-InnoDB tables which do not store any data, but refer to data stored externally in Object Storage, in the following file formats:

• Avro.

• CSV.

• JSON.

  As of MySQL 8.4.0, Lakehouse supports Newline Delimited JSON.

• Parquet.

  See: Section 5.7.1, “Parquet Data Type Conversions”.

The external table stores the location of the data, see Section 5.5, “Access Object Storage”.