{"id":7110,"date":"2023-11-15T08:00:16","date_gmt":"2023-11-15T16:00:16","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=7110"},"modified":"2024-01-23T12:20:44","modified_gmt":"2024-01-23T20:20:44","slug":"microsoftcopilotforazureincdb","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/microsoftcopilotforazureincdb\/","title":{"rendered":"Microsoft Copilot for Azure enables natural language queries for Azure Cosmos DB data"},"content":{"rendered":"

We are thrilled to announce Microsoft Copilot for Azure in Azure Cosmos DB is now in public preview! Microsoft Copilot for Azure<\/a>\u00a0is an AI companion that simplifies how you design, operate, optimize, and troubleshoot from cloud to edge. Copilot\u2019s integration into Azure Cosmos DB is an amazing AI-powered capability that can create Azure Cosmos DB NoSQL queries based on your natural language questions about your data!<\/p>\n

With Copilot, you don’t have to worry about the syntax or the structure of your NoSQL queries. Just type in your English-language question about your data and items in your Azure Cosmos DB collection, and Copilot will generate a query suggestion for you. Every generated query suggestion also contains a natural language explanation of the query, which can help you to understand and validate the query generated by Copilot. This empowers you to quickly and easily access your data stored in Azure Cosmos DB, and also learn how to write NoSQL queries better.<\/p>\n

As a preview feature, you’ll have to add Microsoft copilot for Azure in Cosmos DB preview to your Azure subscription. Learn more about preview features here<\/a>. Once enrolled, you can find Microsoft Copilot for Azure integrated with the Data Explorer\u2019s query editor. Just click on the Copilot icon and start asking questions about your data. Copilot will enter query suggestions into the query editor pane where you can also copy, edit, or execute them. Try it out today and see how Copilot can help you write NoSQL queries faster and easier!<\/p>\n

Getting Started<\/h2>\n

To use Copilot to write NoSQL queries faster and easier, you can follow these steps:<\/p>\n

0. Enroll your Azure subscription in the Microsoft Copilot for Azure in Cosmos DB preview feature<\/a>.<\/p>\n

1. Open the Azure portal and navigate to your Azure Cosmos DB NoSQL resource.<\/p>\n

2. Navigate to the Data Explorer query editor within the NoSQL API.<\/p>\n

3. Select the database and collection you\u2019d like to query:<\/p>\n

    \n
  1. \n
      \n
    1. \n
        \n
      1. You can select any of your databases and collections that you have access to in the MY DATA<\/em> section of the left-hand navigation pane. Once the collection is chosen, you can right-click select New SQL Query <\/em>or select New SQL Query <\/em>in the toolbar.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

        \"Getting<\/a><\/p>\n

        b. Or you can choose the sample database CopilotSampleDb<\/em> from the SAMPLE DATA <\/em>to use a pre-populated collection. This can also be accessed quickly by selecting the \u201cQuery faster with Copilot\u201d card.<\/p>\n

        \"Data<\/a><\/p>\n

        4. Type a clear and concise question about the data you are looking for in the prompt box. Use keywords and context that are relevant to the Azure Cosmos DB document structure. Specify properties and any filtering criteria as explicitly as possible. Avoid ambiguous or overly complex language in your prompts.<\/p>\n

        5. Click on the Generate Query<\/em> button to see the suggested NoSQL query based on your prompt. You can also see the AI explanations of how the query works below the suggestion.<\/p>\n

        \"Microsoft<\/a><\/p>\n

        6. All Copilot generated queries should be reviewed and verified before executing them. If you are satisfied with the suggested query, you can copy it to the clipboard or execute it directly in the query editor. You can also modify the query as you wish before executing it or refine your existing prompt, for more guidance see the FAQ<\/a>.<\/p>\n

        7. You can also provide feedback to the Copilot team by clicking on the thumbs up or thumbs down icons next to the suggestion. This will help inform the product team where the Copilot is performing well, and where there are opportunities for improvement.<\/p>\n

        \"Microsoft<\/a><\/p>\n

        That\u2019s how you can use Copilot to query your data using natural language and learn how to write queries faster. Microsoft Copilot for Azure is an AI companion that unlocks the full power of Azure. We hope that Copilot will make your data querying experience more enjoyable and productive.<\/p>\n

        Related Links<\/h2>\n

        Learn how to sign up for Microsoft Copilot for Azure preview<\/a><\/p>\n

        Learn how to use the preview of Microsoft Copilot for Azure to write Azure Cosmos DB NoSQL queries<\/a><\/p>\n

        Transparency FAQ<\/a><\/p>\n

        Learn more about Microsoft Copilot for Azure<\/a><\/p>\n

        About Azure Cosmos DB<\/h2>\n

        Azure Cosmos DB is a fully managed and serverless distributed database for modern app development, with SLA-backed speed and availability, automatic and instant scalability, and support for open-source PostgreSQL, MongoDB, and Apache Cassandra.\u00a0Try Azure Cosmos DB for free here.<\/a>\u00a0To stay in the loop on Azure Cosmos DB updates, follow us on\u00a0Twitter<\/a>,\u00a0YouTube<\/a>, and\u00a0LinkedIn<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

        We are thrilled to announce Microsoft Copilot for Azure in Azure Cosmos DB is now in public preview! Microsoft Copilot for Azure\u00a0is an AI companion that simplifies how you design, operate, optimize, and troubleshoot from cloud to edge. Copilot\u2019s integration into Azure Cosmos DB is an amazing AI-powered capability that can create Azure Cosmos DB […]<\/p>\n","protected":false},"author":133447,"featured_media":7133,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[14],"tags":[],"class_list":["post-7110","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-core-sql-api"],"acf":[],"blog_post_summary":"

        We are thrilled to announce Microsoft Copilot for Azure in Azure Cosmos DB is now in public preview! Microsoft Copilot for Azure\u00a0is an AI companion that simplifies how you design, operate, optimize, and troubleshoot from cloud to edge. Copilot\u2019s integration into Azure Cosmos DB is an amazing AI-powered capability that can create Azure Cosmos DB […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/7110","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\/133447"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/comments?post=7110"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/7110\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media\/7133"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media?parent=7110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/categories?post=7110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/tags?post=7110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}