Skip to main content
Last updated on

Configure OAuth for HubSpot ingestion

Learn how to configure HubSpot for ingestion from HubSpot Marketing Hub 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 only the following scopes. Omitting any of these or adding additional scopes will cause failures later in the setup process.

    • 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.

On this page