Azure Synapse Analytics includes many features and capabilities, among those is the COPY command which makes copying data into a data warehouse very easy. This video will walk you though using the COPY command to import data into a data warehouse table for use by data consumers.
Azure Synapse Analytics SQL Dedicated Pool Architecture| Microsoft Docs
Distributed tables design guidance – Azure Synapse Analytics | Microsoft Docs
Design guidance for replicated tables – Azure Synapse Analytics | Microsoft Docs
COPY Command Reference | Microsoft Docs