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

Proposed Solution: In an Azure Synapse Analytics pipeline, you use a Get Metadata activity that retrieves the DateTime of the files.

Does this solution meet the goal?