firebase / extensions

Source code for official Firebase extensions
https://firebase.google.com/products/extensions
Apache License 2.0
882 stars 373 forks source link

[firestore-bigquery-export] create_time and update_time fields not exported #2049

Open pehrlich-arbor opened 2 months ago

pehrlich-arbor commented 2 months ago

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). However, these do not appear in the ..._raw_latest view or ..._raw_changelogtable.

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