cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

How do you run a query as the owner but use a parameter as a viewer

ncouture
Contributor

I have a query that is hitting a table I have access too. Granting access to everyone is not an option. I am using this query in a SQL Dashboard. One of the where clause conditions uses a parameter populated by another query. I want this parameter query to run as the viewer when I share the dashboard to limit what options are presented based on who the viewer is. But its not working that way. It is running it as the owner, ie me, as all options are being shown in the parameter despite having that query saved as run as the viewer.

Is this functionally possible? Or will the parameter query always inherit the permissions from the query calling it?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

ncouture
Contributor

It is not possible to do what I want. Somewhat seems like a security flaw but what ever

View solution in original post

1 REPLY 1

ncouture
Contributor

It is not possible to do what I want. Somewhat seems like a security flaw but what ever

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!