Greetings community, I am new to using databricks and for some time I have tried some scripts in notebook. I would like your help on a task: Carry out a personalized mailing where,
First, a query of the number of records in the test table is performed, the notebook should be executed if it meets the range of 80,000 to 90,000 records, otherwise the notebook should not be executed.
Second, the result of that must notify by mail the current amount of that table and details of why the notebook was not executed.
Third, the message that is sent to the mail must be from the user who runs the notebook and send to corresponding senders.
I really wanted to try it with notifications or alerts but I have not achieved the expected result.