How to query data stored in Data lake Gen2: can we access the data using Azure data studio. What are the different options

Question

Hello,

We are studying the fact to store data in Azure Data lake. The question is we want to know, how is it possible to query the data stored in Azure data lake (CSV files).

Whet is the best solution, can this be done using Azure data studio....

Answer 1

Hello @Anonymous,

Thanks for question and using MS Q&A platform.

Unfortunately, you cannot us e Azure Data Studio for querying data stored in Azure Data Lake Gen2.

Reason: Azure data studio is a tool to connect to databases.

Then how to query data stored in Azure Data Lake Gen2:

You can use one of the programing lanugage to work with Data.

You can use one of the Azure services with Data Lake Storage Gen2.

For more details, refer to Tutorials that use Azure services with Azure Data Lake Storage Gen2.

Hope this helps. Do let us know if you any further queries.

---

Please don’t forget to Accept Answer wherever the information provided helps you, this can be beneficial to other community members.