Hello Ganapathy Ram,
As I mentioned earlier, kafka notification is your best tool when new data assets are added or deleted.
You can also use the workflow automation feature within Microsoft Purview.
Workflows are automated, repeatable business processes that users can create within Microsoft Purview to validate and orchestrate CUD (create, update, delete) operations on their data entities. Enabling these processes allows organizations to track changes, enforce policy compliance, and ensure quality data across their data landscape.
Please see the below documentation for your reference.
https://learn.microsoft.com/en-us/purview/concept-workflow
I hope this answers your question.