Blog Post

Azure Synapse Analytics Blog
4 MIN READ

How Azure Synapse Analytics enables you to run T-SQL queries over your Data Lake files

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Jun 08, 2020
One of the important features of Azure Synapse Analytics is the ability to analyze the files placed on Azure Data Lake Storage (ADLS) and Azure Blob Storage using Transact-SQL language. Azure Synapse...
Updated Jun 08, 2020
Version 2.0
Synapse SQL
edkreuk72's avatar
edkreuk72
MVP
Jun 12, 2020

I especially like the way that you can now connect directly to PowerBI from your DataLake in which you saved the Parquet files via the SQL on Demand functionality and still have your MetaData. Previously you had to do that via a csv file on the DataLake or via an SQL database and then to PowerBI. A great seamless en easy integration in 1 Portal