Delta table zero downtime

[databrciks]

Hello Experts

How to load everyday full load to delta table(truncate and load). The reports are pointing to this table.

How to ensure the zero downtime while load is on.

Thanks

[Sumit_7]

@databrciks Load your new data into a staging table, then replace the target using CREATE OR REPLACE TABLE or INSERT OVERWRITE.
Delta Lake writes are atomic, so reports keep reading the old data until the new load finishes. There is no downtime and no empty table window. Once the load commits, all users automatically see the new data.