I'm trying to alter a table definition, but it's dependent on a materialized view which is managed by RedShift Auto Materialization and not by us. So attempting

ALTER TABLE my_table
    ALTER COLUMN my_column TYPE VARCHAR(100);

Errors with

[0A000] ERROR: cannot alter type of a column used by a materialized view

So I attempt to drop the materialized view

DROP MATERIALIZED VIEW pg_automv.auto_mv_53022635;

Which gives a permission error

[42501] ERROR: permission denied for schema pg_automv

1 Answer 1


It's not possible, they are fully managed by AWS. The solution from AWS support is to turn off AutoMV and reboot to drop all AutoMV.

That is harsh.

  • I would think automvs are non schema bound to avoid this, I haven’t experienced it yet
    – user433342
    Oct 19, 2022 at 16:27
  • @user433342 Materialized views don't have that option, they are always schema bound.
    – Kit Sunde
    Oct 25, 2022 at 21:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.