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, where each source file row will become one row in the table. You need to ensure that when the source data files are loaded into container1, a DateTime value is stored as an additional column in Table1.

You propose the following solution: Use a dedicated SQL pool to create an external table that includes an additional DateTime column.

Does this solution meet the goal?