Build an AI App GraphQL Endpoint with SQL DB in Fabric​

Features

This lab will guide you through creating a set of GraphQL RAG application APIs that use relational data, Azure OpenAI, and SQL DB in Fabric.

Key Learning Objectives:

• Query and work with data in SQL DB in Microsoft Fabric
• Build AI application design pattens/endpoints
• Use AI with relational data
• Understand how similarity searching benefits queries

Overview

1. The Azure Fabric Portal and creating a SQL database in Fabric
2. Working with the SQL Database in Microsoft Fabric
3. REST in the database
4. Creating embeddings for relational data with Azure OpenAI
5. Create a set of GraphQL endpoints for AI Applications
6. Create a PowerBI report with Copilot
7. DevOps in Fabric (demo only)

Getting Started

Prerequisites

• Fabric Capacity (including SQL Database)
• Azure OpenAI Service with the following models deployed:
  • gpt-4
  • text-embedding-ada-002
• Azure OpenAI Service endpoint location and auth keys

Workshop Guide

• Workshop Guide
• Slides
• Azure DevOps and SQL Video