Is it possible to rename a table in Redshift without propagating the change to dependent views?

Question

I noticed that if you rename a table in Redshift the new name is automatically progagated to all the views that are based on that table.

Is there a way to prevent this behavior so that the view definition would contain the old table name?

Answer 1

Looks like this feature was introduced to Redshift. See WITH NO SCHEMA BINDING in the Redshift docs.

CREATE VIEW i_am_view_are_you AS
SELECT good_column
FROM public.i_am_table
WITH NO SCHEMA BINDING