topic Re: Materialize view creation is failed in Data Engineering

Materialize view creation is failed

shsalami — Mon, 16 Sep 2024 23:11:37 GMT

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

select *

from lhdev.gld_sbx.customer

szymon_dybczak — Tue, 17 Sep 2024 10:12:28 GMT

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 — Wed, 25 Sep 2024 05:13:24 GMT

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