search

ToolJet / ToolJet

Low-code platform for building business applications. Connect to databases, cloud storages, GraphQL, API endpoints, Airtable, Google sheets, OpenAI, etc and build apps using drag and drop application builder. Built using JavaScript/TypeScript. 🚀
https://tooljet.com
GNU Affero General Public License v3.0
26.78k stars 3.29k forks source link

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

Open ShazanRizvi opened 2 weeks ago

ShazanRizvi commented 2 weeks ago

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 commented 2 weeks ago

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

mansukh-tj commented 1 week ago

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

Sadaf-A commented 1 week ago

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