# \#bigquery

**URL:** https://community.holistics.io/tag/bigquery/4.md

[Latest](https://community.holistics.io/latest.md) · [Categories](https://community.holistics.io/categories.md) · [Tags](https://community.holistics.io/tags.md)

---

## [When using BigQuery, median fails when combined with SQL \`aggregation\_type: custom\` fields](https://community.holistics.io/t/when-using-bigquery-median-fails-when-combined-with-sql-aggregation-type-custom-fields/2129)

<div class="topic-metadata">

**Author:** [@anya.conti](https://community.holistics.io/u/anya.conti)\
**Replies:** 3\
**Last updated:** [October 16, 2024, 5:06pm UTC](https://community.holistics.io/t/when-using-bigquery-median-fails-when-combined-with-sql-aggregation-type-custom-fields/2129 "2024-10-16T17:06:13Z")

</div>

In BigQuery, the primary out of the box function to calculate median (PERCENTILE\_CONT) can only be used as part of a window function. This seems to work when combined with AQL functions that are aggregating or when comb…

---

## [How manage required column filters in Holistics](https://community.holistics.io/t/how-manage-required-column-filters-in-holistics/1355)

<div class="topic-metadata">

**Author:** [@Chris](https://community.holistics.io/u/Chris)\
**Replies:** 1\
**Last updated:** [January 12, 2023, 5:29am UTC](https://community.holistics.io/t/how-manage-required-column-filters-in-holistics/1355 "2023-01-12T05:29:53Z")

</div>

Hi, Some of the tables I’m working in are fairly large and it is reasonable to have required filters for columns such as ‘created\_at’ to avoid querying a full table. I’ve come across two problems in Holistics when using…

---

## [BigQuery issue when a column has the same name with a BigQuery dataset](https://community.holistics.io/t/bigquery-issue-when-a-column-has-the-same-name-with-a-bigquery-dataset/763)

<div class="topic-metadata">

**Author:** [@datbth](https://community.holistics.io/u/datbth)\
**Replies:** 0\
**Last updated:** [February 24, 2022, 3:00am UTC](https://community.holistics.io/t/bigquery-issue-when-a-column-has-the-same-name-with-a-bigquery-dataset/763 "2022-02-24T03:00:38Z")

</div>

We found out that when a column name has the same name as a dataset, BigQuery will try to use that column instead of the dataset. In the following examples, I was querying from my BigQuery database that has a table ads …

---

## [BigQuery: Can not query from table whose source is Google Sheet](https://community.holistics.io/t/bigquery-can-not-query-from-table-whose-source-is-google-sheet/30)

<div class="topic-metadata">

**Author:** [@triet.pham](https://community.holistics.io/u/triet.pham)\
**Replies:** 0\
**Last updated:** [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")

</div>

When you are querying data from BigQuery and encounter this error Exec SQL failed: \[{"message" : "Not found: Files /gdrive/id/......", "reason =\> notFound"}\] It looks like the table is linked to a Google Sheet and you …