Materialize view creation is failed

[shsalami]

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

[szymon_dybczak]

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."

[shsalami · Accepted solution]

Thanks, it was caused by '%s' in the notebook.