Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,919 questions
How to query synapse analytical store using backend python code?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 50%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sandeep S
0
Reputation points
I have implemented a system where my application writes data to a Cosmos DB (Mongo API) database. Additionally, I have set up a Synapse Analytics link, which creates an analytics store and synchronizes data in real-time from the transactional store (Cosmos DB with Mongo API) to the analytical store.
I now need to query the analytical store to perform various analysis-related tasks. Is there a way I can achieve this using backend code such as Python, Node.js, Java, etc.? While I am aware that this can be done using Synapse Studio in the Azure portal, where I can utilize Spark or SQL notebooks, I am specifically looking for a backend implementation.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga 5,990 Reputation points Microsoft Vendor2024-04-11T07:10:33.72+00:00 Hi @Sandeep S
Welcome to Microsoft Q&A platform and thanks for posting your question here.Yes, it is possible to query the Synapse Analytics store using backend code such as Python, Node.js, or Java. The Synapse Analytics link synchronizes data in real-time from the Cosmos DB (Mongo API) database to the analytical store. You can use Synapse Apache Spark 3 to interact with Azure Cosmos DB and query the analytical store from Spark by loading to a Spark Data Frame or creating a Spark table.
This can be done using the Synapse workspace gestures or by writing code in Scala, Python, Spark SQL, or C#
I hope this helps! Let me know if you have any further questions.
-
Harishga 5,990 Reputation points Microsoft Vendor
2024-04-12T05:56:40.0166667+00:00 @Sandeep S
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer