How to prevent users from scheduling SQL queries?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2023
07:46 AM
- last edited on
03-21-2025
05:49 AM
by
Advika
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?
- Labels:
-
SQL

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2023 05:21 AM
@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

