# BigQuery: Can not query from table whose source is Google Sheet

**URL:** <https://community.holistics.io/t/bigquery-can-not-query-from-table-whose-source-is-google-sheet/30>\
**Category:** Common Error Messages\
**Tags:** bigquery\
**Created:** [November 15, 2018, 4:04am UTC](https://community.holistics.io/t/bigquery-can-not-query-from-table-whose-source-is-google-sheet/30 "2018-11-15T04:04:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![triet.pham](https://community.holistics.io/user_avatar/community.holistics.io/triet.pham/32/10_2.png) [@triet.pham](https://community.holistics.io/u/triet.pham)\
**Post date:** [November 15, 2018, 4:04am UTC](https://community.holistics.io/t/bigquery-can-not-query-from-table-whose-source-is-google-sheet/30/1 "2018-11-15T04:04:41Z")

</div>

When you are querying data from BigQuery and encounter this error

```auto
Exec SQL failed: [{"message" : "Not found: Files /gdrive/id/......", "reason => notFound"}]

```

It looks like the table is linked to a Google Sheet and you will need to share that Google Sheet to the Google service account. The Google service account is the one that you create when [connecting Holistics to Bigquery](https://docs.holistics.io/docs/bigquery-setup#section-connecting-holistics-to-bigquery).

Just follow these step [How to query Google Sheet via BigQuery](https://docs.holistics.io/docs/bigquery-setup#section-google-sheets-via-bigquery) and your issue would be resolved.