Redshift Materialized View: error when creating with glue catalog

54 views Asked by At

I try to create a materialized view via spektrum from an external table in the glue data catalog

CREATE MATERIALIZED VIEW "dev"."public"."table_name" AS
SELECT DISTINCT *
FROM "awsdatacatalog"."my_db"."table_name" 

but I get the following error and have no idea where to start looking for a solution:

Trying to make internal datasharing request for auto mounted catalog. code: 4
0

There are 0 answers