Databricks Community

dtb_usr · 02-03-2026

I am having to pass ownership of pipelines to users for them to read materialised views associated with any pipeline otherwise they get a 'User does not have SELECT on table...' error. This is obviously bonkers as any pipeline can only have one owner...

dtb_usr · 11-18-2024

Hi,There are versions of this question posted already but they seem to refer to legacy features. Our organisation uses google workspace IP provisioned via Okta as the first landing point and all apps are secured behind this. We have purchased Databri...

dtb_usr · 10-07-2024

How do I ingest sensitive data from a googlesheet doc to Databricks unity catalogue without making the googlesheet public.

dtb_usr · 02-03-2026

Hi, So the query runs fine in SQL Editor but not in notebooks with personal cluster

dtb_usr · 02-03-2026

[INSUFFICIENT_PERMISSIONS] Insufficient privileges: User does not have SELECT on Table'catalogue_name. schem_name. __materialization_mat_xxx_xxx_materialised_view_name'. SQLSTATE: 42501

dtb_usr · 02-03-2026

Hi Saritha_S,Thanks for the reply. I have understood your point on ownership of the pipeline. My issue is with access to the materialised view. Are you saying that materialised views created created by a pipeline can only be viewed and read by the pi...

dtb_usr · 02-03-2026

I am having the same issue. I am having to pass ownership of pipelines to users for them to read materialised views associated with any pipeline otherwise they get a 'User does not have SELECT on table...' error. This is obviously bonkers as any pipe...

dtb_usr · 11-19-2024

Hi @Alberto_Umana thanks for the quick reply. We tried this solution but it didnt do what we wanted. After configuring SCIM via Okta, we are still led to the google login page in databricks (attached screenshot) but what we need is for the login page...

Databricks Community

User Stats

User Activity

SELECT Permission error when reading materialised views associated with a pipeline

Okta SSO Unified login in GCP

Creating a private connection with Google Sheets

Re: SELECT Permission error when reading materialised views associated with a pipeline

Re: SELECT Permission error when reading materialised views associated with a pipeline

Re: SELECT Permission error when reading materialised views associated with a pipeline

Re: When accessing a view in Unity Catalog; access to underlying tables of the view is also needed.

Re: Okta SSO Unified login in GCP