Insufficient privileges error when running query from Notebook
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 11:21 AM
Hello all,
I am running into a permission issue when running a simple MERGE INTO query from a Notebook: " AnalysisException: [INSUFFICIENT_PERMISSIONS] Insufficient privileges: User does not have USE SCHEMA on Schema 'system.query'."
I can run the query interactively through the SQL Editor with no errors. What am I missing here?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 01:17 PM
On a related note... I am not seeing my notebook queries in the query history interface. I was trying to confirm that the queries run from the notebook would run with my user id, but I don't see these queries at all.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 03:26 PM
Are you using an all purpose cluster or a SQL warehouse to run this query in the notebook?
