Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2024 04:11 PM
I have 'ALL_PRIVILEGES' and 'USE_SCHEMA' on lhdev.gld_sbx schema but the following command has been failed with the error:
DriverException: Unable to process statement for Table 'customermvx'
create materialized view customermvx
as
select *
from lhdev.gld_sbx.customer
Labels:
- Labels:
-
Delta Lake
1 ACCEPTED SOLUTION
Accepted Solutions
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-24-2024 10:13 PM
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-17-2024 03:12 AM
Hi @shsalami ,
According to below documentation snippet, you also need USE CATALOG privilege on the parent catalog.
"The user who creates a materialized view (MV) is the MV owner and needs to have the following permissions:
- SELECT privilege over the base tables referenced by the MV.
- USE CATALOG privilege on the parent catalog and the USE SCHEMA privilege on the parent schema.
- CREATE MATERIALIZED VIEW privilege on the schema for the MV."
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-24-2024 10:13 PM
Thanks, it was caused by '%s' in the notebook.

