Materialize view creation is failed

shsalami · ‎09-16-2024

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 · ‎09-17-2024

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 · ‎09-24-2024

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