2026-07-06 - Google Sheets Pattern and Drive Scopes Fix for ADC¶
Release¶
AgileData.io - Sheets and Drive Working Again: Credential Scope Fix for ADC Clients
Following the migration to Application Default Credentials (ADC) for client authentication, an issue was identified where the BigQuery client running with ADC wasn’t including the Google Drive scopes required for accessing Google Sheets. This affected workflows that use Google Sheets as a data source — the client had the right identity but lacked the permission to access Drive-based resources.
The Drive scopes have been added to both the BigQuery client in the functions layer and the shared Google Sheets access pattern in the API layer, restoring full Google Sheets functionality for ADC-based tenancy configurations.
What was happening:
BigQuery client running with ADC was missing the Google Drive scopes needed to access Sheets
The shared Google Sheets access pattern in the API was not aligned with the ADC credential approach
What this means for you:
Google Sheets sources work correctly in tenancies using ADC-based authentication
Data pipelines that read from Google Sheets continue to function after the ADC migration
Last Refreshed¶
Doc Refreshed: 2026-07-06