Configure OAuth for Google Ads ingestion
This feature is in Beta.
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.
Set up OAuth 2.0 credentials
-
Visit https://console.cloud.google.com and navigate to APIs & Services > Credentials.
-
Click Create credentials and select OAuth client ID.
-
Set the Application type to Web application.
-
Under Authorized redirect URIs, add the following:
https://<deployment>.databricks.com/login/oauth/google.htmlReplace
<deployment>with your Databricks workspace deployment URL. -
Click Create and save the Client ID and Client secret. You'll need these values when creating your Databricks connection.
Make sure the Google Ads API is enabled in your Google Cloud project and that the OAuth consent screen for this client includes the https://www.googleapis.com/auth/adwords scope. When you create the connection and click Sign in with Google Ads, Databricks requests this scope. If the scope is missing or the API is not enabled, sign-in fails.
Confirm the Google Ads API access level
Google Ads API access is granted to the Google Cloud project that owns your OAuth client. You don't need a developer token.
- In the Google Cloud console, select the project that contains your OAuth client.
- Go to the Google Ads API Overview page for the project and check its access level.
- If the access level is Test, apply for Basic or Standard access. A project with Test access can't read production Google Ads accounts.
For details, see Access levels in the Google Ads API documentation.
Identify your Manager Account ID
If you manage multiple Google Ads accounts using a Manager Account (MCC), collect the 10-digit Manager Account ID:
- Log in to your Google Ads Manager Account.
- 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 Create a Google Ads connection.