Skip to main content
Last updated on

Configure OAuth for Google Ads 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 Google Ads to enable authentication from Databricks. The managed Google Ads connector in Lakeflow Connect uses OAuth 2.0 user-to-machine (U2M) authentication. You'll use the authentication details that you retrieve from the steps on this page to create a Unity Catalog connection in Databricks.

Get a developer token​

  1. Sign in to your Google Ads Manager Account at https://ads.google.com/aw/apicenter.
  2. Go to Admin > API Center.
  3. Either apply for a new developer token or use an existing one:
    • Use an existing developer token if your organization already has one available for this Google Ads Manager Account.
    • Apply for a new developer token only if you don't have access to an existing token, or if you're setting up the integration under a different Google Ads Manager Account.

The developer token must have at least standard access for production workloads. Basic access is fine for non-production workloads.

Set up OAuth 2.0 credentials​

  1. Visit https://console.cloud.google.com and navigate to APIs & Services > Credentials.

  2. Click Create credentials and select OAuth client ID.

  3. Set the Application type to Web application.

  4. Under Authorized redirect URIs, add the following:

    https://<deployment>.databricks.com/login/oauth/google.html

    Replace <deployment> with your Databricks workspace deployment URL.

  5. Click Create and save the Client ID and Client secret. You'll need these values when creating your Databricks connection.

Identify your Manager Account ID​

If you manage multiple Google Ads accounts using a Manager Account (MCC), collect the 10-digit Manager Account ID:

  1. Log in to your Google Ads Manager Account.
  2. Look at the top-right corner of the page. Your 10-digit Customer ID will be listed next to your profile picture or account name.

Next steps​

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