Send realtime, incremental updates from a specified Cloud Firestore collection to BigQuery

You can use Rowy's low-code UI for Firebase to send realtime, incremental updates from a specified Cloud Firestore collection to BigQuery. Start with ready-to-use code blocks for cloud functions and tweak them in any way you like in JS/TS with a built-in code editor. Deploy in one click to your own Firebase project on Google Cloud. No DevOps, CLIs, or configs to deal with. Give it a quick spin by following these steps.

Step 1: Setup Rowy

Connect Rowy to your existing Firebase project or create a new one from scratch

Step 2: Connect to your BigQuery account

If there is a connectivity to the tool available via API secret key then you can store this in your project secret manager on Google Cloud Platform. You can use any NPM module or API using fetch

Step 3: Add ready to use code block for BigQuery streaming insert

With Rowy you can build quickly like low-code using ready to use code block but you have full flexibility to go down to code level and extend anytime you need to add your business logic

Step 4: Pick the data fields

In the code simply point to the data fields that should trigger your event - create / update / delete of rows, incoming webhook event, and specific time- based event. Fields will be streaming into BigQuery in realtime as they are updated in Cloud Firestore. Step 5: That's it You can simply deploy this as a cloud function to Firebase in one click. No DevOps, CLIs, terminal, configs to deal with. Focus just on building the logic of your cloud functions.