Create alert and send notification to owner of table

subbaram — Fri, 29 Dec 2023 09:32:21 GMT

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?

Re: Create alert and send notification to owner of table

shan_chandra — Thu, 11 Jan 2024 17:39:06 GMT

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

topic Re: Create alert and send notification to owner of table in Warehousing & Analytics

Create alert and send notification to owner of table

Re: Create alert and send notification to owner of table