Microsoft One Drive

This documentation describes the integration of MindsDB with Microsoft OneDrive, a cloud storage service that lets you back up, access, edit, share, and sync your files from any device.

​

Prerequisites

1. Before proceeding, ensure that MindsDB is installed locally via Docker or Docker Desktop.
2. Register an application in the Azure portal.
   • Navigate to the Azure Portal and sign in with your Microsoft account.
   • Locate the Microsoft Entra ID service and click on it.
   • Click on App registrations and then click on New registration.
   • Enter a name for your application and select the Accounts in this organizational directory only option for the Supported account types field.
   • Keep the Redirect URI field empty and click on Register.
   • Click on API permissions and then click on Add a permission.
   • Select Microsoft Graph and then click on Delegated permissions.
   • Search for the Files.Read permission and select it.
   • Click on Add permissions.
   • Request an administrator to grant consent for the above permissions. If you are the administrator, click on Grant admin consent for [your organization] and then click on Yes.
   • Copy the Application (client) ID and record it as the client_id parameter, and copy the Directory (tenant) ID and record it as the tenant_id parameter.
   • Click on Certificates & secrets and then click on New client secret.
   • Enter a description for your client secret and select an expiration period.
   • Click on Add and copy the generated client secret and record it as the client_secret parameter.
   • Click on Authentication and then click on Add a platform.
   • Select Web and enter URL where MindsDB has been deployed followed by /verify-auth in the Redirect URIs field. For example, if you are running MindsDB locally (on https://localhost:47334), enter https://localhost:47334/verify-auth in the Redirect URIs field.

​

Connection

Establish a connection to Microsoft OneDrive from MindsDB by executing the following SQL command:

CREATE DATABASE one_drive_datasource
WITH
    engine = 'one_drive',
    parameters = {
        "client_id": "12345678-90ab-cdef-1234-567890abcdef",
        "client_secret": "abcd1234efgh5678ijkl9012mnop3456qrst7890uvwx",
        "tenant_id": "abcdef12-3456-7890-abcd-ef1234567890",
    };

Required connection parameters include the following:

• client_id: The client ID of the registered application.
• client_secret: The client secret of the registered application.
• tenant_id: The tenant ID of the registered application.

​

Usage

Retrieve data from a specified file in Microsoft OneDrive by providing the integration name and the file name:

SELECT *
FROM one_drive_datasource.`my-file.csv`;
LIMIT 10;

The special files table can be used to list the files available in Microsoft OneDrive:

SELECT *
FROM one_drive_datasource.files LIMIT 10

The content of files can also be retrieved by explicitly requesting the content column. This column is empty by default to avoid unnecessary data transfer:

SELECT path, content
FROM one_drive_datasource.files LIMIT 10

​

Troubleshooting Guide