Choosing the Right Settings for Data Refresh

A client needs a daily refresh of a Lakehouse table to ensure that it always contains the latest and most accurate data. They also require that any outdated records are completely removed during each refresh. Schema changes might occur occasionally, such as adding new columns, and they are fine with rebuilding relationships or measures if needed. Which settings should you choose?