Create alert and send notification to owner of table

[subbaram]

We have a use case where we need to send notification to owners of each table/volume in a schema if the creation date for table/volume is greater than 30 days by triggering a notebook script or through Rest API.

Will there be a chance that we get the owner of volume/table on the fly and create an alert first with owner email(which will be dynamic) as destination and then send out a notification to the owners?

[shan_chandra]

Hi @subbaram  - you can create a simple python script by quering system tables - system.information_schema.tables  and create a dynamic list where creation date > 30 days and alert the table_owner via email. 

Hope this helps !!!

Thanks,

Shan