Create alert and send notification to owner of table

subbaram
New Contributor II

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?