How to easily open and query parquet files using Microsoft Azure and T-SQL

This video will show you how to open parquet files so you can read them. We upload them into an Azure Storage Account using Azure Synapse. Then we query the parquet file using T-SQL. This is all very affordable

[charliemmadad]

Thank you for making this video. I was able to query all of the parquet files to answer a client question without bugging a data engineer.

[sambo]

that was super useful and concise, thank you!

[josephcarrier]

Can you save the new set of data as a parquet in a Data Lake or something?

[nagoorpashashaik]

Can i use this parquet query in derived column in dataflow activity

it doesn't explain how to integrate this retrieving in a pipeline, how to read row by row a parquet file in a pipeline, and doing some activity on the rows