Export capability (CETAS) for Data Virtualization in Azure SQL Managed Instance generally available

Thank you for this lesson NikolaZagorac & 

just completed a POC on Data Archiving from Sql MI using this.

Need help on these questions please -

1) How can we Append records into CETAS table since DML operations are disallowed. ?

Since my work is about Archival of sql server tables, one way is to - create CETAS for each archival year like Cetas_2023_CustTab, Cetas_2024_CustTab and then UNION these in a View for Application to use.

This all have to be executed periodically through dynamic code and also rebuild the final view to include new CETASes.

2) I used Parquet file as CETAS format and found no easy method to merge the files programmatically. Am thinking to experiment with JSON now. Since I could write simple Powershell to merge 2 JSONs.

Any feedback?

-- LR