{"id":5765,"date":"2023-03-15T09:00:11","date_gmt":"2023-03-15T16:00:11","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=5765"},"modified":"2023-03-16T22:23:20","modified_gmt":"2023-03-17T05:23:20","slug":"announcing-data-api-builder-for-azure-cosmos-db","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/announcing-data-api-builder-for-azure-cosmos-db\/","title":{"rendered":"Announcing Data API builder for Azure Cosmos DB"},"content":{"rendered":"

We are super excited to announce the public preview of Data API builder<\/span>. A new feature that allows customers to <\/span>instantly and securely build a <\/span>GraphQL<\/span> API<\/span> for Azure Cosmos DB for NoSQL and Azure Cosmos DB for PostgreSQL.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

A quick look at Data API Builder\u00a0<\/span><\/p>\n

With Data API Builder, database objects can be exposed via REST or GraphQL endpoints so your data can be accessed on any platform, any language, and any device. Support for Azure SQL, SQL Server, PostgreSQL, MySQL and <\/span>Azure <\/span>Cosmos DB provides API developers with an efficiency boost never seen before.<\/span> Developers can quickly build GraphQL and REST APIS by self-hosting or integrating Data API builder in their Static Web App, eliminating the effort needed to build custom code. Developers only need to provide basic information for database connection, entities, and permissions in a simple configuration file. Data API Builder can use the configuration file and GraphQL type schema file to generate the GraphQL endpoint to perform CRUD operations on your data. Data API Builder does not support REST endpoint when used with Azure Cosmos DB for NoSQL; instead, you can use the Azure Cosmos DB REST<\/span> API.<\/span><\/a>\u00a0<\/span><\/p>\n

\u00a0<\/span> \"Image<\/a><\/span><\/p>\n

\u00a0<\/span>Figure: Data API Builder architecture<\/span><\/i>\u00a0<\/span>\u00a0<\/span><\/p>\n

Features of Data API Builder for Azure Cosmos DB<\/span><\/h2>\n
Build with existing or new databases<\/span>\u00a0<\/span><\/h5>\n

Data API Builder gives you the flexibility to build APIs on the data you already have in any of the supported databases and does not require you to store your data in any specific format. It also provides a rich end-to-end developer experience including a CLI which enables rapid development,<\/span>\u00a0all you need to do is provide Data API Builder with a connection string and basic schema and permissions information in a simple configuration file. No code is <\/span>required<\/span>! <\/span>Your application will then <\/span>have the ability to<\/span> perform CRUD operations securely.<\/span><\/span><\/p>\n

Make powerful queries<\/span>\u00a0<\/span><\/h5>\n

Data API Builder for Azure Cosmos DB supports <\/span>querying a single item. Or, using the filter engine you can perform paginated queries for multiple items. Mutations are provided to insert, update, and delete data from your database.<\/span>\u00a0<\/span><\/p>\n

Fine-grained access control<\/span>\u00a0<\/span><\/h5>\n

Data API Builder for Azure Cosmos DB allows several levels of data access and authorization depending on the needs of an application. Data API Builder for Azure Databases supports AAD Managed Identity and when integrated with Static Web App, it provides enterprise security and fine-grained access control. To secure data access, you can use the built-in role-based access control with Static Web Apps authentication integration to limit access to your database to certain users or roles.<\/span>\u00a0<\/span><\/p>\n

Out of the box integration with Azure Static Web Apps<\/span>\u00a0<\/span><\/h5>\n

Data API builder has been tightly integrated into Azure Static Web Apps enabling you to quickly build <\/span>dynamic web apps that scale via the new SWA Database connections feature. It powers you to deploy the entire application with backend connectivity using <\/span>Azure <\/span>Cosmos DB with a simple git push.<\/span>\u00a0<\/span><\/p>\n

\"Image<\/a>Database connections with Azure Static Web Apps<\/span><\/p>\n

This is made available in your development environment via the Static Web Apps CLI emulator (SWA CLI) for consistency across development,<\/span> enable you to get <\/span>stated<\/span> building <\/span>your <\/span><\/span>apps<\/span> without<\/span> the need to<\/span> wait<\/span> on <\/span>or invest in separate <\/span>b<\/span>ackend <\/span>development <\/span>effort <\/span>needed <\/span>to <\/span>create <\/span>APIs<\/span> fo<\/span>r data<\/span> access.<\/span> <\/span><\/span><\/p>\n

Benefits:\u00a0<\/span><\/h2>\n