You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?
Azure Functions
Microsoft SQL Server Integration Services (SSIS)
PolyBase
Azure Data Factory
Submit