How to prevent users from scheduling SQL queries?

pauloquantile — Fri, 21 Mar 2025 12:49:40 GMT

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?

Re: How to prevent users from scheduling SQL queries?

Anonymous — Tue, 20 Jun 2023 12:21:32 GMT

@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:

Cluster-level permissions
Jobs API
Notification hooks
Audit logs and monitoring

topic Re: How to prevent users from scheduling SQL queries? in Warehousing & Analytics

How to prevent users from scheduling SQL queries?

Re: How to prevent users from scheduling SQL queries?