# Optimal way to configure BigQuery/ BigQuery Bi Engine for Observable?

**URL:** <https://talk.observablehq.com/t/optimal-way-to-configure-bigquery-bigquery-bi-engine-for-observable/6230>\
**Category:** Help\
**Created:** [February 15, 2022, 8:46pm UTC](https://talk.observablehq.com/t/optimal-way-to-configure-bigquery-bigquery-bi-engine-for-observable/6230 "2022-02-15T20:46:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![harkanwals](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.observablehq.com/harkanwals/32/6120_2.png) [@harkanwals](https://talk.observablehq.com/u/harkanwals)\
**Post date:** [February 15, 2022, 8:46pm UTC](https://talk.observablehq.com/t/optimal-way-to-configure-bigquery-bigquery-bi-engine-for-observable/6230/1 "2022-02-15T20:46:48Z")

</div>

What is the best way to keep query cost low? Are there any general recommendations for using BigQuery with Observable?

Lastly, does BigQuery BI Engine work with Observable, or rather has anyone tried using it?

---

<div class="post-metadata">

**Author:** ![hellonearthis](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.observablehq.com/hellonearthis/32/3935_2.png) [@hellonearthis](https://talk.observablehq.com/u/hellonearthis)\
**Post date:** [February 15, 2022, 9:16pm UTC](https://talk.observablehq.com/t/optimal-way-to-configure-bigquery-bigquery-bi-engine-for-observable/6230/2 "2022-02-15T21:16:33Z")

</div>

These notebook might help:

- [How to cache BigQuery results in a public Notebook with Firebase Storage or a Cloud Bucket / Endpoint Services / Observable](https://observablehq.com/@endpointservices/cache-bigquery)
- [Schema Generator for synchronizing external state into BigQuery / Tom Larkworthy / Observable](https://observablehq.com/@tomlarkworthy/synchronizing-external-state-into-bigquery-efficiently)
- [Connecting to databases / Observable / Observable](https://observablehq.com/@observablehq/databases)

---

<div class="post-metadata">

**Author:** ![visnup](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.observablehq.com/visnup/32/305_2.png) [@visnup](https://talk.observablehq.com/u/visnup)\
**Post date:** [February 16, 2022, 3:04pm UTC](https://talk.observablehq.com/t/optimal-way-to-configure-bigquery-bigquery-bi-engine-for-observable/6230/3 "2022-02-16T15:04:08Z")

</div>

I don’t have a good answer to the best configuration question, but would love to know if you come to any conclusions.

I’ve also not heard of anyone using Observble with BI engine but it seems possible? I’d need to read through the docs more on how to configure usage with BI engine…

---

<div class="post-metadata">

**Author:** ![harkanwals](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.observablehq.com/harkanwals/32/6120_2.png) [@harkanwals](https://talk.observablehq.com/u/harkanwals)\
**Post date:** [February 16, 2022, 9:17pm UTC](https://talk.observablehq.com/t/optimal-way-to-configure-bigquery-bigquery-bi-engine-for-observable/6230/4 "2022-02-16T21:17:19Z")

</div>

Thanks! I will report back on what I discover with BI engine.