Integrate Teams with Genie using Azure Serverless Framework in 30mins!

A Teams Bot that integrates with Databricks Genie using conversational APIs, allowing users to query and interact with their data directly from Teams.

Features

• 🤖 Conversational AI: Ask questions about your data in natural language

• 💬 Threaded Conversations: Maintain context across multiple messages in Teams Channels

• 📊 Rich Responses: Get query results and reasoning directly in Slack

• 🔄 Real-time Feedback: Provide feedback to Genie directly from Teams

• 🔐 Secure: Uses Azure AD Authentication with OAuth 2.0 and service principals

Architecture

Prerequisites

• Azure Access - with permissions to create resources

• Azure CLI Setup

• Azure Databricks workspace

• Databricks Genie space

Setup Instructions

1. Azure Resources Setup

Prepare Application Code

Download application code from repo https://github.com/adgitdemo/ad_databricks/tree/main/genie-teams-app and make necessary updates to config values in .env based on reference in config.env. Execute install.sh script. This script will take care of everything for you as listed below.

• Creates Resource Group

• Creates Storage Account

• Creates Function App

• Creates App Registration & Service Principal

• Generates client secret

• Adds Azure Databricks API permission

• Configures Function App settings

• Deploys code

• Creates Bot Service

• Enables the Teams channel

• Creates Teams app package

The script will output all resource names along with a zip file to be used for the Teams application setup. Once the installation script is successfully completed,

1. Add service principal to Databricks (App ID: xxxxxx-xxx-xxx-xxxxx-xxxxxxx)

You will first need to add a service principal at the account level, and later same needs to be added at the workspace level

2. Grant Genie space access and catalog/schema/table access to the service principal

3. Upload Teams app: databricks-genie-teams-app-xxxxxx.zip (appears as: DB Genie xx)

4. Test in Teams!

Usage

In Teams

1. Direct Messages:

   • Send a DM to your bot

   • Ask questions like: “Show me sales data for last month”

2. Mentions in Teams:

   • Add the bot to a Team/channel

   • Mention the bot: @YourBotName, what are the top 10 customers?

3. Threaded Conversations within Teams/Channels:

   • Continue asking questions in a thread

   • The bot maintains conversation context within threads

Demo Time

Start chatting with Databricks Genie Bot

Let’s ask real question,

You should give feedback to Genie Bot, and it will get recorded in Databricks Genie, and the author of Genie Space will review it!