I'm currently working on Postgresql migration to Azure SQL database and needed to convert Postgres materialized views into Azure SQL. I cannot used SQL server indexed views since existing Postgres materialized views are sourcing from other views and are using UNION and AGGREGATE FUNCTIONS which are limitations of indexed views. My initial plan is to create physical table that will hold same data as the view. Is there any alternative way of how to refresh the data on the table without recreating the table itself?
Please advise.