You have an Azure Synapse Analytics dedicated SQL pool with a table named Table1. Data files are ingested into an Azure Data Lake Storage Gen2 container named container1. You plan to insert and transform data from these files into Table1, with each file row producing one row in the table. You need to ensure that when the source data files are loaded into container1, the current DateTime is stored as an additional column in Table1.

Proposed Solution: Use an Azure Synapse Analytics serverless SQL pool to create an external table that includes an additional DateTime column.

Does this solution meet the goal?