Recently we ve upgraded from 24.0.1-202303312317430103-9ff7aeed to 25.0.7-202407181421320869-2632b04f. AWS Edition (activated)
What we noticed is that some VDS shows old SQL definition in UI when we click to Edit it(like history is trimmed).
While in reality latest definition is IN USE(i.e Querying VDS shows correct results/column list and Reflection Tab shows correcty columns list incompatible with wrong sql definition).
Also correct sql is shown, when we query it using select * from sys.views where view_name = ...
There’s a feature called view schema learning which will automatically update the view schema when some dependent table or view causes the view’s schema to change. This happens when the view is queried and we detect that the view’s schema no longer matches the view’s SQL schema.
However, for what you describe, I have not seen an issue where the view schema is up to date but the view SQL is stale.