Create an Outlook connection

Create an Outlook connection in Catalog Explorer to store OAuth 2.0 machine-to-machine (M2M) authentication credentials for Lakeflow Connect ingestion. Any user with the USE CONNECTION privilege on the connection can then create Outlook ingestion pipelines without needing direct access to the credentials.

Alternatively, admin users can create a connection and a pipeline at the same time in the data ingestion UI. See Create an ingestion pipeline.

For privilege requirements, see Connect to managed ingestion sources.

Prerequisites

Complete the source setup. Use the authentication details you obtain to create the connection.

Create a connection

1. In the Databricks workspace, click Catalog > External locations > Connections > Create 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 Outlook.
4. (Optional) Add a comment.
5. Click Next.
6. On the Authentication page, enter the following credentials:
   • Client ID: The application (client) ID from your Microsoft Entra app registration.
   • Client secret: The client secret value from your Microsoft Entra app registration.
   • Tenant ID: The directory (tenant) ID from your Microsoft Entra app registration.
7. Click Create connection.

Next steps

Create an ingestion pipeline.