LOAD_HISTORY and COPY_HISTORY Information Schema views: Showing only post-truncate load history¶

The LOAD_HISTORY and COPY_HISTORY Information Schema views show results as follows:

Before the change:

The LOAD_HISTORY and COPY_HISTORY views show load history from both before and after the latest truncate operation on the target table.

After the change:

The LOAD_HISTORY and COPY_HISTORY views show load history only after the latest truncate operation on the target table.

After the behavior change, you can still see pre-truncate load history by querying the views and saving the load history before truncating the target table. You can also query the views in the Account Usage schema, which contains a longer history and includes the pre-truncate operations.

Ref: 1493