DEV Community

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

Posted on • Edited on

9

Brace yourself: Using BigQuery as an operational backend

Liquid syntax error: Unknown tag 'endraw'

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

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 !

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay