CREATE OR REPLACE VIEW v_t
COPY GRANTS
AS
SELECT * FROM t;
After running the above if I create a new column in source table and run select * from v_t it breaks with "query produces Y columns but declared only X"
Did anyone have a fix for this. Cannot hardcode the column names because the underlying table in my case in dynamic. I cannot recreate the view every time the table updates its DDL.