Google Ad Manager Reporting API Authentication via Databricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2022
01:01 PM
- last edited on
03-21-2025
06:30 AM
by
Advika
Hello - I was wondering whether anyone has had any experience fetching data through GAM's Reporting API via Databricks.
The Reporting API requires installation of the "googleads" library, as well as a googleads.yaml file. I was able to find some documentation online where you can either load the yaml file from storage by specifying a location for it, or load it through a yaml string.
ad_manager:
application_name: INSERT_APPLICATION_NAME_HERE
network_code: INSERT_NETWORK_CODE_HERE
path_to_private_key_file: INSERT_PATH_TO_FILE_HERE
Within the yaml file or string it also asks about a path to the specific json private key file, but I'm not sure how to attach the location relative to Databricks. The private key file also contains credentials which I want to limit user access to, so a DBFS upload may not work in this case since it's shared across the organization.
I was wondering if anyone has insight connecting via a service account/yaml to Google Ad Manager Reporting via Databricks, and how I can go about successfully authenticating the ad manager client.