How to read data from integration dataset using SQL

@Dolase, Vishal
Thank you for the question and for using Microsoft Q&A platform.

As per my understanding, you are trying to query from an Integration Dataset.
We cannot query a dataset while creating it. But you can query it while using it in a pipeline. I have provided an example below:

I have created an integration dataset for a SQL database:

After creating a dataset, add this as the source to Copy data activity. You can query the table here with the query option:

learn.microsoft.com/en-us/azure/data-factory/concepts-datasets-linked-services?tabs=data-factory
techcommunity.microsoft.com/blog/azuresynapseanalyticsblog/ingest-and-transform-data-with-azure-synapse-analytics-with-ease/1975563

Hope this helps. Do let us know if you have any further queries. ———— If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.