To prevent the data in a Lakehouse table from getting outdated, refresh the tables using incremental load. This feature is available in MySQL 9.0.0 and later versions.

For more information, see Section 5.5.1, “Refreshing Data Using Incremental Load”.

To edit the list of files comprising a Lakehouse table without altering the directories in the Object Storage bucket, use selective load. This feature is available in MySQL 9.1.2 and later versions.

For more information, see Section 5.5.2, “Adding or Removing Files Using Selective Load”.