Welcome to an exciting, new workshop where we blend the power of AI with the versatility of GraphQL and SQL databases in Microsoft Fabric. This guide will walk you through creating a set of GraphQL RAG (Retrieval-Augmented Generation) application APIs, leveraging relational data and Azure OpenAI.

What You’ll Learn

You’ll dive into querying and managing data within SQL databases in Microsoft Fabric and mastering the art of building AI application endpoints. We’ll explore how to seamlessly integrate AI with relational data and enhance your queries with similarity searching.

The Adventure Begins

Here is the chapter breakdown and what you will do:

1. Azure Fabric Portal & SQL Database Setup: Start by navigating the Azure Fabric Portal and setting up your SQL database. This is your foundation.
2. Working with the SQL Database in Microsoft Fabric: Get hands-on with the features and functionalities of SQL databases in Microsoft Fabric including Copilot.
3. RESTful Services: Discover how to utilize RESTful services within your database to enhance functionality.
4. Embedding Relational Data with Azure OpenAI: Learn to create embeddings for your relational data, adding a layer of intelligence to your applications.
5. GraphQL Endpoints for AI: Develop GraphQL endpoints tailored for AI applications, making your data more accessible and interactive.
6. PowerBI Reports with Copilot: Use Copilot to generate insightful PowerBI reports, turning data into actionable insights.
7. DevOps in Fabric: Get a glimpse of DevOps within the Fabric environment through a demo video. You can also perform the same steps in your Microsoft Fabric environment.

Key Learning Objectives of the Workshop

Here are the key learning objectives for the workshop:

• Learn how to efficiently query and manage data within SQL databases in Microsoft Fabric.
• Understand the design patterns necessary for building robust AI application endpoints.
• Discover how to integrate AI capabilities with relational data to enhance your applications.
• Learn how similarity searching can improve the efficiency and accuracy of your queries.

And the slides for this workshop are here.

Getting Started

To begin, ensure you have the following prerequisites:

• Fabric Capacity, including a SQL Database.
• Azure OpenAI Service with the following models deployed: gpt-4 and text-embedding-ada-002.
• Azure OpenAI Service endpoint location and authentication keys.

When ready, access the workshop guide here.

By the end of this workshop, you’ll have a comprehensive understanding of how to build and deploy AI application endpoints using GraphQL, SQL DB, and Azure OpenAI within Microsoft Fabric. Happy coding! 🚀

Feel free to reach out if you have any questions or need further assistance or ideas for future workshops!