Configure OAuth U2M: Databricks-managed for Microsoft OneDrive ingestion

Important

This feature is in Beta. Workspace admins can control access to this feature from the Previews page by opting into the Lakeflow Connect for OneDrive For Business preview. See Manage Azure Databricks previews.

This page describes how to configure OAuth U2M: Databricks-managed authentication for Microsoft OneDrive ingestion into Azure Databricks. With this method, Azure Databricks manages the OAuth app registration and token refresh automatically. No Microsoft Entra ID app registration is required.

Tip

This is the recommended authentication method for most users. If your organization requires control over the OAuth application registration, or if OAuth U2M: Databricks-managed isn't listed in your workspace, see OAuth U2M: Custom-managed instead.

Prerequisites

  • A Azure Databricks workspace with Unity Catalog enabled.
  • The CREATE CONNECTION privilege on the metastore.
  • A Microsoft work or school account that can access the OneDrive for Business My files drive you want to ingest.

Create the connection

  1. In the Azure Databricks workspace, click Data icon. Catalog > Create > Create a connection.
  2. On the Connection basics page of the Set up connection wizard, specify a unique Connection name.
  3. In the Connection type drop-down menu, select Microsoft OneDrive.
  4. In the Auth type drop-down menu, select OAuth U2M: Databricks-managed.
  5. Click Next.
  6. Click Sign in with Microsoft OneDrive.
  7. In the sign-in window, choose the Microsoft work or school account whose OneDrive you want to ingest, then grant the requested permissions if prompted.
  8. Click Create connection.

Warning

Only share this connection with other Azure Databricks users if you authenticated with a service account in the previous step. If you authenticated with a personal account, do not share the connection. Sharing a personal-account connection grants other users access to your personal account's credentials and data.

Next steps

  1. Ingest data from OneDrive
  2. Common pipeline maintenance tasks
  • Last updated on