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,600 questions
Connect and query to Azure database for PostgresSql from Synapse Analytics
![](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(201.6, 34%, 29%)' 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)
Sathya Sai Cheetirala
0
Reputation points
Hi,
Is there a way to connect and query Azure Database for PostgresSql from Synapse Analytics.We need near real time data from postgres database to join the CosmosDB data in Synapse Analytics.
I would really appreciate for the input.
Thanks!
{count} votes
-
Sathya Sai Cheetirala 0 Reputation points
2024-06-13T12:40:16.7933333+00:00 currently we are using serverless sql pool for querying the Azure cosmosDB using synapse link,
we want to join the data from potgres and cosmos db for analytics
-
![](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,420 Reputation points Microsoft Vendor2024-06-14T08:18:26.6833333+00:00 Hi @Sathya Sai Cheetirala
Welcome to Microsoft Q&A platform and thanks for posting your question here.To connect and query Azure Database for PostgreSQL from Synapse Analytics and join it with CosmosDB data for analytics, you can follow these steps:
Create a Linked Service to Azure Database for PostgreSQL:
- Navigate to the Manage tab in your Azure Data Factory or Synapse workspace.
- Select Linked Services, then click New.
- Search for PostgreSQL and select the Azure database for PostgreSQL connector.
- Configure the service details, test the connection, and create the new linked service.
Use Copy Activity in Azure Data Factory and Synapse Analytics Pipelines:
- Utilize the Copy Activity to copy data from and to Azure Database for PostgreSQL.
- Use Data Flow to transform data in Azure Database for PostgreSQL.
Query Azure Cosmos DB Data Using Serverless SQL Pool:
- Use the serverless SQL pool in Azure Synapse Analytics to query data from Azure Cosmos DB containers enabled with Azure Synapse Link.
- The full SELECT surface area is supported through the OPENROWSET function, which includes the majority of SQL functions and operators.
Join Data from PostgreSQL and CosmosDB:
- Create SQL views to join data in the analytical stores across multiple Azure Cosmos DB containers.
- Organize your data in a semantic layer that will accelerate your data exploration and reporting workloads.
https://devblogs.microsoft.com/cosmosdb/synapse-sql-serverless-preview/
I hope this information helps you. Let me know if you have any further questions or concerns.
-
Harishga 5,420 Reputation points Microsoft Vendor
2024-06-17T04:44:29.6133333+00:00 @Sathya Sai Cheetirala
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