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

[harkanwals]

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?

[hellonearthis]

These notebook might help:

• How to cache BigQuery results in a public Notebook with Firebase Storage or a Cloud Bucket / Endpoint Services / Observable
• Schema Generator for synchronizing external state into BigQuery / Tom Larkworthy / Observable
• Connecting to databases / Observable / Observable

[visnup]

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…

[harkanwals]

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