Databrcks + sharepoint +Microsoft Teams Bot

[foubs]

I recently created a Teams Bot using Databricks Genie, and some of the data I want to retrieve from Databricks can be very large. 

The solution I am thinking of is for every bot request which will lead to lots of rows and columns to be retrieved, I want to enable Databricks Genie to write the data in the form of csv file to SharePoint and then get the sharepoint location and share to the teams bot, so that the user can click on the sharepoint link within teams and download the csv file. 

[KaushalVachhani]

@foubs, in that case, you may need to write custom code that takes a response from the Genie Conversation API, saves it as a CSV file, and uploads it to SharePoint. This file can then be accessed through your Teams Bot for download as needed.

If this doesn't work, can you elaborate on your use case and the current implementation?

[foubs]

Hello @KaushalVachhani I was trying to find out if Databricks already has a template for this part "Genie Conversation API, saves it as a CSV file, and uploads it to SharePoint" 

Because the data might be big, eg more than 50 rows with more than four columns. 

[twole]

Hi Foubs,

You could look into using the Databricks n8n nodes to build this custom workflow. 

Here is a template of an Agent with Genie (the repo shows you how to install n8n on Databricks)

You can include a Teams and SharePoint node in your workflow to build out your idea.