search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.22k stars 21.37k forks source link

Documentation is incomplete and a non-starter #117002

Closed nagi49000 closed 4 months ago

nagi49000 commented 10 months ago

The documentation talks about 'inputing queries', and says nothing about what to input them into, or how to input them.

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

SaibabaBalapur-MSFT commented 10 months ago

@nagi49000 Thanks for your feedback! We will investigate and update as appropriate.

AjayBathini-MSFT commented 10 months ago

@nagi49000 Could you please elaborate the query for better understanding. So, we can assist you further.

nagi49000 commented 10 months ago

The tutorial describes queries, and says to run them. It says nothing about what to run them in, how to run them, or how to get results from them. Code without a way to run them is just text; there's nothing that can be done with the code. How should a user run that query? What should they enter the query into?

azaricstefan commented 10 months ago

@nagi49000 did you try to execute any of the queries?

Queries are using public datasets. You can copy-paste the SQL code in one of the clients of your choice (ADS/SSMS/Synapse Studio) and check the results. Here is an example: image

If you don't have a Synapse workspace you can create it and you will get serverless SQL pool created automatically with it.

nagi49000 commented 10 months ago

Hi - no I didn't run any of the queries since the tutorial didn't say anything about how or where I should run the queries; I couldn't run any queries since I didn't know how to run them. Saying in the docs how or where to run the queries would be useful (such as creating a workspace, creating an SQL script etc). I was able to work this out for myself after a couple of hours by creating an ADF pipeline to put a parquet in Gen2 storage from some data I had in Cosmos, and run an SQL script on the parquet URL.... but that feels like self-learning I shouldn't have had to do, and been able to pick up from the docs. I really think saying HOW to run the queries, and not just WHAT the queries are, is useful instruction to have in something that's meant to be a tutorial.

azaricstefan commented 7 months ago

Hi @nagi49000

There is a requirement that you already have a Synapse workspace in order to execute any T-SQL code on Synapse SQL serverless SQL pools.

You can follow this tutorial to get started with creating Synapse workspace.

bandersmsft commented 4 months ago

Thanks for your dedication to our documentation. Unfortunately, at this time we have been unable to review your issue in a timely manner and we sincerely apologize for the delayed response. We are closing this issue for now, but if you feel that it's still a concern, please respond and let us know. If you determine another possible update to our documentation, please don't hesitate to reach out again. #please-close