topic Re: Insufficient privileges error when running query from Notebook in Get Started Discussions

Insufficient privileges error when running query from Notebook

WWoman — Tue, 28 May 2024 18:21:05 GMT

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?

Re: Insufficient privileges error when running query from Notebook

WWoman — Tue, 28 May 2024 20:17:24 GMT

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.

Re: Insufficient privileges error when running query from Notebook

mhiltner — Tue, 28 May 2024 22:26:10 GMT

Are you using an all purpose cluster or a SQL warehouse to run this query in the notebook?