5.8.4 Lakehouse Limitations for the JSON File Format

• As of MySQL 8.4.0, Lakehouse only supports Newline Delimited JSON.

• Tables created with json format must only have a single column that conforms to the JSON data type, see: The JSON Data Type.

• Lakehouse can only load 64KB of data for each line, and ignores any line with more than 64KB of data.