Can I access the data in Azure Synapse using any of the native SDKs like Azure-CLI?
What is the best way to run queries on Azure synapse from an external application??
Is there a way we can use Rest APIs for this purpose?
Can I access the data in Azure Synapse using any of the native SDKs like Azure-CLI?
What is the best way to run queries on Azure synapse from an external application??
Is there a way we can use Rest APIs for this purpose?
Hello @VijaySampathTrianz-9530 and welcome to Microsoft Q&A.
There are many SDK's / API. Most of the controls are for managing the Synapse rather than retrieving data from Synapse. All the SDKs are linked from the documentation under "reference".

You can also connect to Synapse from other applications like Visual Studio Code, SQL Server Management Studio, and others. The precise selection differs on which sub-service you want to connect to (SQL serverless, SQL dedicated, Spark, Integration, Azure Storage)
Thanks for your response @MartinJaffer-MSFT
My use-case requirement is to run queries from AWS-Lambda to fetch data from Azure-synapse tables.
What is the best option provided by Azure to achieve this?
I am looking into the Native Azure SDKs because we have heavy load of data and the Native SDKs perform better than the other options in such scenarios.
Much of what Synapse provides is compute, orchestration, and management. Depending upon how the data is kept, you may want to try using the Storage API's. That would let you fetch data direct from the storage account.
7 people are following this question.