Marketplace
>
syncFirestoreCollectionWithBigQuery
rainbow

syncFirestoreCollectionWithBigQuery

v
0.0.2
Latest Version
Likes
0
4
Installations
0
4
Views
0
21

Overview

Synchronize a Firestore collection into a BigQuery table.

Usage

### How this function works You can use this function to sync the documents in a Firestore collection with BigQuery. The function sends incremental and real-time updates whenever a document in the collection changes; this means that only documents that are modified **AFTER** the installation of this feature will be synced. ### Prerequisites * You must have previous knowledge of **BigQuery**. * You must have previous knowledge of **Firestore**. ### Function details This function listens for changes to documents within the specified collection and then synchronizes it with the provided BigQuery table. It will store a complete change history of the documents within your collection along with some metadata fields: `timestamp`, `document_name`, and `operation`. If the dataset and table do not exist, the function will create them for you. It will also create a view that represents the current state of the data. To install this function, you must specify the path to the Firestore collection, the name of the dataset, the table, and the view. Add the required information to the form with the following parameters: * **Document Path**: The document path that you'd like this function to listen to. A placeholder should be used for the document id (e.g., `users/{userId}`). * **DATASET_NAME**: The name of the dataset to store the documents. * **TABLE_NAME**: The name of the table to store the documents. * **VIEW_NAME**: The name of the view that represents the current state of the data.
Cost
FREE
Cost
Version
0.0.2
Language
JAVASCRIPT
Created At
Updated At
Workspace
rainbow
Tags
bigquery
firestore
© 2023 Function Store