Microsoft Teams <-> Databricks Genie API - End to End Integration
Integrating Databricks’ AI/BI Genie with Microsoft Teams revolutionizes how business teams interact with data, enabling seamless natural language queries within their collaboration environment. This integration empowers users to ask questions and receive insights directly in Teams, streamlining decision-making processes. By leveraging the Genie API, organizations can enhance productivity and foster a data-driven culture. In this blog, we’ll explore the step-by-step process to set up this integration, ensuring your team can harness the full potential of Databricks and Microsoft Teams.
This blog is only focussed on integrating the azure bot to MS Teams, to configure your bot, the underlying infrastructure and the genie space please visit this blog by my colleague Ryan Bates.
There are multiple ways to deploy your bot into MS Teams, for this blog we will be using a manifest file and deploying that into the Teams portal.
Step 1:
Please note down your application ID of the Bot you have just deployed.
You can find this by navigating to
Azure portal → Resource group you created → Azure Bot → Configuration
Step 2:
For the next step you would now need to create a manifest file, there are multiple ways to create a manifest file, but for this example we will be using Kyle Hale’s manifest, which can be found in his repo here.
To create the manifest file, you would need to download the folder.
Once downloaded, navigate to the manifest.json file inside and replace the values in the keys bots/botId and webApplicationInfo/id with the application ID from Step 1 (i.e., lines 42 and 54).
The folder also contains two files: color.png and outline.png. These are the bot logos and can be replaced with your custom logos. Ensure they retain the same names (color.png and outline.png), or else the changes will not be reflected
After modifying the code you would need to create a manifest file, to do this navigate to the genie-teams-app folder and run the following command in your terminal
For Mac users
zip genie-teams.zip ./*For Windows users
Compress-Archive -Path * -DestinationPath genie-teams.zip
Keep this file safe.
Step 3:
This step involves uploading the manifest file to Teams. We will be doing this via the Developer Portal.
Azure bot can only be integrated to MS Teams Commerical or MS Teams Government.
Many organisation might restrict individual contributors from uploading custom apps to Microsoft Teams, which can lead to difficulties in testing the bot resource. To overcome this, you can enrol in Microsoft’s Developer Program, where current Visual Studio Professional or Enterprise subscribers and members of qualifying programs can set up a free Microsoft 365 E5 developer subscription for development purposes.”
You can sign up using your organisation’s email address, which will grant you free access to Microsoft 365 services for 90 days.
After creating the developer account, you will be assigned an email address, which we will use to sign into Teams.
Download the Microsoft Teams app and sign in with the user account you just created
Once signed in, you should see the Developer Portal icon on the left. Click on that — you should see the following screen
Click on ‘Import an app’ and select the ZIP file you created in Step 2
Now, click on ‘Publish’ and choose ‘Publish to your org’
click on ‘Preview in Teams’ in the right-hand corner to start using the bot.
Conclusion:
Using Genie on Teams makes data accessible on the go without the need to log in to the Databricks workspace.
By following the steps above, you can successfully integrate Databricks Genie to MS Teams.
Thank you,Ryan Bates, Luiz Carrossoni Neto and Kyle Hale for all the work and effort to make this dream to a reality
