DEV Community

Cover image for Brace yourself: Using BigQuery as an operational backend
matthieucham for Stack Labs

Posted on • Edited on

Brace yourself: Using BigQuery as an operational backend

Liquid syntax error: Unknown tag 'endraw'

Top comments (2)

Collapse
 
viroos profile image
Maciej Sawicki

I understand that the example showing cumbersome of Cloud SQL approach was just an excuse to present a nice BigQuery hack, but it worth mention that in such case Firestore may be a better option. For example:

db.collection(u'configtable').add({u'input_attribute': input_value})

Collapse
 
matthieucham profile image
matthieucham

Hi Maciej, you're right Firestore is definitely an option to consider. Here however, I needed to store attributes in a place where I could request it from BigQuery and join with other tables of BigQuery. So Firestore was of no help.
Thanks for your comment !