Check if this can be achieved somehow using - Create external table as select
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-external-table-as-select
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-as-select-transact-sql?view=aps-pdw-2016-au7
----------
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav