firebase / firebase/extensions
[firestore-bigquery-export] create_time and update_time fields not exported
- Dominant language
- TypeScript
- Stars
- 979
- Forks
- 433
- Avg merge
- 1d 13h
- Merged PRs (30d)
- 125
Description
This feature request is for extension: **firestore-bigquery-export**
### What feature would you like to see?
Firestore sets create_time and update_time by default on every document. ([docs](https://cloud.google.com/firestore/docs/reference/rpc/google.firestore.v1beta1#document)). However, these do not appear in the `..._raw_latest` view or `..._raw_changelog`table.
There is a `timestamp` column, which is similar. However, afaict this is not expected or guarenteed to match the firestore `created_time` value, nor is is easy to get separate created and updated timestamps in the `_latest` table.
### How would you use it?
Auditing in-order execution of document creation
Contributor guide
Research direction
The request concerns the firestore-bigquery-export extension and its _raw_latest and _raw_changelog views. Start by tracing how Firestore document fields are exported to BigQuery, using the linked Firestore Document reference. Done means separate create_time and update_time values are available in both views, with the relevant behavior covered by tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- google-cloud, typescript
- Domain
- data, databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 52/100