Create alert and send notification to owner of table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-29-2023 01:32 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2024 09:39 AM
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