4.3.11 Update Tables

4.3.11.1 Refresh Data Using Event-Based Incremental Load

4.3.11.2 Refresh Data Using Incremental Load

4.3.11.3 Add or Remove Files Using Selective Load

You can update loaded external tables by using one of the following methods:

• To prevent the data in a Lakehouse table from getting outdated, refresh the tables using Incremental load. This feature is available as of MySQL 9.0.0.

• To edit the list of files comprising an external table without altering the directories in the Object Storage bucket, you can add or remove files using Selective Load. This feature is available as of MySQL 9.1.2.