[Subtask]: Collect and report expire snapshots event for Mixed and Iceberg format

[xxubai]

Search before asking

• [X] I have searched in the issues and found no similar issues.

Description

No response

Parent issue

#2539

Are you willing to submit PR?

• [X] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct