Configure OAuth for HubSpot ingestion

Beta

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Databricks previews.

Learn how to configure HubSpot for ingestion into Databricks. The managed HubSpot connector in Lakeflow Connect uses OAuth 2.0 user-to-machine (U2M) authentication. Use the authentication details that you retrieve from the steps on this page to create a Unity Catalog connection in Databricks.

Create a public app and retrieve authentication details

1. Visit the legacy HubSpot app page at https://app-na2.hubspot.com/legacy-apps/<hubspot-id>. Replace <hubspot-id> with your HubSpot ID.

2. Click Create Legacy App, then select Public App.

3. On the App Info tab, enter your app details.

4. On the Auth tab, set the redirect URL (format: https://<your_workspace_domain>/login/oauth/lakehousefederation.html). For example: https://e2.our-staging-workspace.cloud.databricks.com/login/oauth/lakehousefederation.html

5. Note the Client ID and the Client secret. Use these to create a Unity Catalog connection in Databricks.

6. Under Scopes > Required scopes, add the following scopes:

   • communication_preferences.read
   • content
   • crm.objects.marketing_events.read
   • crm.objects.marketing_events.write
   • forms
   • forms-uploaded-files
   • marketing.campaigns.read

7. Click Save, then click Create app.

Next steps

Use Catalog Explorer to create a connection so that any user with USE CONNECTION or ALL PRIVILEGES can create pipelines. See HubSpot.