Automation to Save Superset query extract to one drive folder

[saket2912]

Hi, is there a way we can link superset to one drive folder?

How to save a superset query extract to one drive directly?

[dosubot[bot]]

Hey @saket2912! I'm here to help you with any bugs, questions, or contributions. Let me know how I can assist you!

Superset does not have a built-in feature or existing integration to directly export query results to external storage services like OneDrive. However, you can programmatically access and export query results using Superset's API. You could then use a separate script or tool to upload the exported data to OneDrive.

To export query results, you can use the /export/<string:client_id>/ endpoint to get the results in CSV format. After obtaining the CSV file, you can use OneDrive's API or a third-party tool to upload the file to your OneDrive folder ^[1][2][3].

To continue talking to Dosu, mention @dosu.