Hello Team,
Thank you for reaching out. Please note, if the client account is enrolled in 2-Step Verification, the accounts accessing it should also be enrolled for this verification. Please refer to this blog post for more details and information. Also, we strongly recommend using OAuth2 installed app or web flow instead of service accounts unless you need a domain-specific feature (for example, impersonation). For your concern related to integration between BigQuery and AdWords Service accounts, I would recommend reaching out to the Big Query support team as this is outside our expertise. Feel free to reach out if you have any additional API related concerns.
Regards,
Nikisha Patel, Google Ads API Team