Syncing with Google BigQuery

We would love to set up a direct synchronisation with BigQuery so that we can create visualisations and graphics from the data in Baserow. Does anyone else have any idea on how we could achieve this?

Hello @JoshN, first of all, welcome to the Baserow community :wave:

I think the simplest way to achieve that would be to connect Baserow and BigQuery using n8n, but let’s check with @joffcom if that is a good idea :slightly_smiling_face:

1 Like

Hey Hey,

So you could use something like n8n / node-red / zapier to take care of the sync for you but if you were also self hosting Baserow in GCP with Postgres there is a handy tool called Datastream which will allow you to replicate the data to Big Query in real time.

It all depends on what you have available, I would of course probably use n8n to handle it just to have a bit more control over it all and it would allow me to use the Baserow API rather than having to directly deal with the database.

Would the sync be one direction (Baserow > BigQuery) or bi-directional?

Hi team - I solved this with FiveTran. Datastream doesn’t work with the self-hosting option we have. Thanks again