How to prevent users from scheduling SQL queries?

[pauloquantile]

We have noticed that users can schedule SQL queries, but currently we haven't found a way to find these scheduled queries (this does not show up in the jobs workplane). Therefore, we don't know that people scheduled this. The only way is to look at the warehouse query histories, which is not the solution since it requires manual work.

In general, we would like to prevent these from happening. Therefore, we are looking for a solution to disable this or to get a notification once people start scheduling queries.

Does anyone got any ideas how to realise this?

[Anonymous]

@Paulo Rijnberg​ :

In Databricks, you can use the following approaches to prevent users from scheduling SQL queries and to receive notifications when such queries are scheduled:

1. Cluster-level permissions
2. Jobs API
3. Notification hooks
4. Audit logs and monitoring