How to use CETAS on serverless SQL pool to improve performance and automatically recreate it

Liliam_C_Leme It's not that I'm looking for an automated refresh, I think that's easy to build in ADF or similar tools. However I'm looking for an option in the CTAS which does an update so the data in the background is refreshed with the original query (just re-executing it). The data files are created in a separate directory and as soon as it's done preparing the data the directories are switched on the metadata level. So the as long as the refresh is running the table still returns the "old" data and as soon as the data files are provisioned in the data lake SQL Serverless switches to the new data directory. Then the old data directory can be deleted and everything is then leveraging the new data. So we won't have any "downtime" of the table (where the old data is already deleted and the new is not ready, yet). So it's still using the old table name, you don't need any "re-wiring" in Power BI, you  just get the most freshest data available when you run a refresh of your model. 

Makes sense?