question

VijaySampathTrianz-9530 avatar image
0 Votes"
VijaySampathTrianz-9530 asked MartinJaffer-MSFT commented

Azure Synapase native SDK for data access

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?

azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered MartinJaffer-MSFT commented

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".

119575-image.png

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)

get-started-azure-data-studio



image.png (135.7 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

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.


0 Votes 0 ·