BigQuery GDS: Error Fetching Data from Google Sheets Linked Tables in BigQuery

[ShazanRizvi]

Issue Description

When attempting to access data from BigQuery tables linked to Google Sheets within ToolJet, an error occurs. This issue only affects tables linked to Google Sheets; native BigQuery tables function as expected. The Google Sheet is fully accessible, and edit permissions have been granted to the relevant service account.

Steps to Reproduce

1. Create a connection to BigQuery in ToolJet.
2. Attempt to access a table that is linked to a Google Sheet.
3. Observe that an error is thrown, despite the Google Sheet being open for all and the service account having the necessary permissions.

Expected Behavior

The linked BigQuery tables should be accessible and allow data fetching similar to native tables, especially since permissions are correctly set.

Actual Behavior

An error occurs when trying to fetch data from BigQuery tables linked to Google Sheets. Native tables do not show this issue.

[Sadaf-A]

Hey @ShazanRizvi ,
I would like to work on this issue

[mansukh-tj]

Hi @Sadaf-A
This issue has been assigned to you!

[Sadaf-A]

Hey @ShazanRizvi @mansukh-tj , I'm not able to reproduce this issue everything is working fine even after linking BigQuery to google sheets