Hi,
Hope you are doing good.
In Bigquery,
I am working from last 3 years,
In this time i wrote many complex queries.
To make query cost effective ,
We need to create partition tables. clustering of tables.
Also many other factor, in which i can help to create query cost effective and to optimize it.
Also will connect your firestore database with BigQuery.
Thanks.
Mohit (Bigquery Developer)