firebase / firebase/extensions

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

Open
#2,049 1 comment 0 reactions 0 assignees View on GitHub
extension: firestore-bigquery-export type: feature request
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.