Google Big Query Connector | INVALID_PERMISSIONS when querying Google Drive data
Trailblazer Community

Google Big Query Connector | INVALID_PERMISSIONS when querying Google Drive data

Marketing Cloud Intelligence , Marketing Cloud Intelligence Integrations

Last updated 27 days ago ·Reference W-11168380 ·Reported By 2 users

In Review

Summary
Clients are unable to query tables within Google Drive using the GBQ data connector, despite being able to query the same data through the UI without any issues. The error appears when validating the query, with the following message: "Access Denied: Big Query: Permission denied while getting Drive credentials."

Repro
Attempt to validate a Google Big Query query that taps into a Google Drive dataset

Workaround
Data can be uploaded to GBQ and queried directly, or queries can first be performed outside of Datorama and then uploaded to a TotalConnect stream

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.