{"id":9197,"date":"2024-12-03T09:00:35","date_gmt":"2024-12-03T17:00:35","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=9197"},"modified":"2024-12-03T12:19:13","modified_gmt":"2024-12-03T20:19:13","slug":"microsoft-fabric-api-for-graphql-for-azure-cosmos-db-mirroring","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/microsoft-fabric-api-for-graphql-for-azure-cosmos-db-mirroring\/","title":{"rendered":"Microsoft Fabric API for GraphQL\u2122 for Azure Cosmos DB Mirroring"},"content":{"rendered":"

The Microsoft Fabric API for GraphQL\u2122 provides a data access layer that enables you to query multiple data sources quickly and efficiently using a widely adopted and familiar API technology. This API abstracts the specifics of backend data sources, allowing you to focus on your application’s logic and deliver all the data a client needs in a single call.<\/span>\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

Microsoft Fabric’s Mirroring enables you to seamlessly integrate your existing Azure Cosmos DB data with the rest of your data in Microsoft Fabric, eliminating the need for ETL. You can replicate your Azure Cosmos DB data continuously into OneLake in near real-time without affecting the performance of your transactional workloads. Click <\/span>here<\/span><\/a> for more information. This blog post shows you how to integrate these two technologies and build near real-time analytical applications.<\/span>\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

Use Cases Between GraphQL and Azure Cosmos DB in Microsoft Fabric<\/span>\u00a0<\/span><\/h2>\n

Integrating the Microsoft Fabric API for GraphQL\u2122 with mirrored Azure Cosmos DB data empowers developers to build robust real-time analytical applications. GraphQL enables efficient querying by allowing developers to retrieve only the required data from multiple sources, including mirrored data in OneLake, while abstracting backend complexities. This streamlined approach is perfect for applications demanding up-to-date insights, such as live dashboards, analytics platforms, and interactive user interfaces. By mirroring Azure Cosmos DB data into Microsoft Fabric, the system ensures near real-time synchronization, keeping data current without affecting transactional workload performance. This synergy lets developers concentrate on creating responsive, scalable applications that deliver actionable insights and seamless user experiences.<\/span>\u00a0<\/span><\/p>\n

How to mirror your Azure Cosmos DB data into Microsoft Fabric<\/span>\u00a0<\/span><\/h2>\n

To mirror a database, it should already be provisioned in Azure, and continuous backup on the account is a prerequisite. Each database can be mirrored individually. And you can mirror the same database multiple times within the same workspace.\u00a0<\/span>\u00a0<\/span><\/p>\n

To start mirroring your Azure Cosmos DB database into Microsoft Fabric, navigate to the Fabric portal, open an existing workspace or create a new one, select <\/span>Create<\/span><\/b>, locate the <\/span>Data Warehouse<\/span><\/b> section, and then select <\/span>Mirrored Azure Cosmos DB<\/span><\/b> (preview)<\/span><\/b>. For more details, click <\/span>here<\/span><\/a>.<\/span>\u00a0<\/span><\/p>\n

 <\/p>\n

How to query your mirrored data with GraphQL<\/span>\u00a0<\/span><\/h2>\n

\u00a0<\/span>Your Azure Cosmos DB data is mirrored in the open-source delta format and automatically made available to all analytical engines on Fabric through a SQL Analytics Endpoint.\u00a0<\/span>\u00a0<\/span><\/p>\n

\u00a0<\/span>To connect your mirrored Azure Cosmos DB data to the Microsoft Fabric API for GraphQL\u2122, you have two main options. The first is to use the SQL Analytics Endpoint provided by Microsoft Fabric for the mirrored database. This endpoint allows you to execute SQL queries against your mirrored data in OneLake. By integrating this endpoint with your GraphQL queries and mutations, you can directly interact with the mirrored data using familiar SQL syntax within your GraphQL APIs, enabling efficient data retrieval and manipulation.<\/span>\u00a0<\/span><\/p>\n

\u00a0<\/span>The second option involves attaching the mirrored database to a Fabric Warehouse. By doing this, you integrate your Azure Cosmos DB data into the data warehousing environment of Microsoft Fabric. Your GraphQL queries and mutations can then interact with the warehouse data, providing a seamless way to access and analyze large volumes of data in near real-time.<\/span>\u00a0<\/span><\/p>\n

Both methods enable you to efficiently connect and query your mirrored Cosmos DB data through GraphQL. This allows you to choose the approach that best fits your application’s architecture and performance requirements, facilitating the development of responsive and scalable applications.<\/span>\u00a0<\/span><\/p>\n

For more information on how to query mirrored Cosmos DB data in Fabric, please visit <\/span>Query the SQL analytics endpoint or Warehouse in Microsoft Fabric<\/span><\/a>.<\/span>\u00a0<\/span><\/p>\n

Nested Data<\/span>\u00a0<\/span><\/h2>\n

A common issue with mirrored data in Fabric is that JSON data gets replicated as strings. This is less than ideal, since applications expect properly formatted JSON for processing. To address this, you use views and expose the nested data as columns.\u00a0<\/span>\u00a0<\/span><\/p>\n

For this, we need to use the <\/span>OPENJSON<\/span><\/a> function and the <\/span>CROSS APPLY<\/span><\/a> operator in the view definition.\u00a0<\/span>\u00a0<\/span><\/p>\n

Here\u2019s an example of a view that flattens mirrored JSON data into columns:\u00a0<\/span>\u00a0<\/span><\/p>\n

\"Nested<\/a>
This view shows how to read nested data<\/figcaption><\/figure><\/p>\n

How this is used from within an application<\/span>\u00a0<\/span><\/h2>\n

\u00a0<\/span>Attaching the SQL Analytics endpoint or Warehouse to an API for GraphQL item, and choosing the vConsolidatedIoTData view in the object picker, we can very quickly craft a GraphQL request that returns the data that was formatted as columns by the view:<\/span>\u00a0<\/span><\/p>\n

\"GQL<\/a>
GQL sample<\/figcaption><\/figure><\/p>\n

This request can now be used directly in your application, and GraphQL will return correctly formatted JSON back to the requesting client application.<\/span>\u00a0<\/span><\/p>\n

API for GraphQL helps you create code for your application quickly and simply, with the <\/span>Generate<\/span><\/a> code functionality in the editor. Simply click on the Generate code button on your editor, and pick from a list of languages to use in your app.\u00a0<\/span>\u00a0<\/span><\/p>\n

\"Python<\/a>
Python sample<\/figcaption><\/figure><\/p>\n

For more information on how to leverage Fabric API for GraphQL in your applications, please visit <\/span>Connect applications to Fabric API for GraphQL<\/span><\/a>.<\/span>\u00a0<\/span><\/p>\n

Conclusion<\/span>\u00a0<\/span><\/h2>\n

\u00a0<\/span>In conclusion, integrating Microsoft Fabric API for GraphQL\u2122 with mirrored Azure Cosmos DB data offers a robust solution for building near real-time analytical applications. By harnessing GraphQL’s efficient querying capabilities and the seamless data integration provided by Microsoft Fabric, developers can create responsive and scalable applications with ease. Whether you choose to connect through the SQL Analytics Endpoint or attach the mirrored database to a Fabric Warehouse, this approach enables efficient access to up-to-date data, empowering you to deliver rich insights and exceptional user experiences.<\/span>\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

More Resources<\/span>\u00a0<\/span><\/h2>\n

Here are some more resources that you may find interesting:<\/span>\u00a0<\/span><\/p>\n

API for GraphQL Overview and Documentation<\/span><\/a>\u00a0<\/span><\/p>\n

Mirroring Azure Cosmos DB (Preview)<\/span><\/a>\u00a0<\/span><\/p>\n

\u00a0<\/span>Leave a review<\/span><\/b>\u00a0<\/span><\/h2>\n

Tell us about your Azure Cosmos DB experience! Leave a review on PeerSpot and we\u2019ll gift you $50. <\/span>Get started here<\/span><\/a>.<\/span>\u00a0<\/span><\/p>\n

About Azure Cosmos DB<\/span><\/b>\u00a0<\/span><\/h2>\n

Azure Cosmos DB is a fully managed and serverless NoSQL and vector database for modern app development, including AI applications. With its SLA-backed speed and availability as well as instant dynamic scalability, it is ideal for real-time NoSQL and MongoDB applications that require high performance and distributed computing over massive volumes of NoSQL and vector data.<\/span>\u00a0<\/span><\/p>\n

Try Azure Cosmos DB for free here.<\/span><\/a> To stay in the loop on Azure Cosmos DB updates, follow us on <\/span>X<\/span><\/a>, <\/span>YouTube<\/span><\/a>, and <\/span>LinkedIn<\/span><\/a>.<\/span>\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

The Microsoft Fabric API for GraphQL\u2122 provides a data access layer that enables you to query multiple data sources quickly and efficiently using a widely adopted and familiar API technology. This API abstracts the specifics of backend data sources, allowing you to focus on your application’s logic and deliver all the data a client needs […]<\/p>\n","protected":false},"author":21894,"featured_media":9200,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[14],"tags":[],"class_list":["post-9197","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-core-sql-api"],"acf":[],"blog_post_summary":"

The Microsoft Fabric API for GraphQL\u2122 provides a data access layer that enables you to query multiple data sources quickly and efficiently using a widely adopted and familiar API technology. This API abstracts the specifics of backend data sources, allowing you to focus on your application’s logic and deliver all the data a client needs […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/9197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/users\/21894"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/comments?post=9197"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/9197\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media\/9200"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media?parent=9197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/categories?post=9197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/tags?post=9197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}