This project leverages Azure Synapse Analytics service to create pipelines to copy data from a local SQL server table and a local CSV file into Azure Data Lake Gen 2. Subsequently, serverless SQL pools are employed to cleanse and transform this data, rendering it into a state suitable for analytical/reporting use in serverless Data Warehouse views.