'Why does BigQuery only ingest Crashlytics logs timestamps with seconds precision, when Crashlytics has them in milliseconds?

I’m using the connector for syncing Firebase Crashlytics into BigQuery. In Crashlytics, the log messages have milliseconds in their timestamps. However, once they reach BigQuery, they lose the milliseconds precision and are only in seconds, even if I use the timestamp_millis function (see the third column in the second screenshot). Has anyone experienced this issue or can help?

Crashlytics (original data showing milliseconds precision)

BigQuery (3rd column is ingested timestamp with only seconds precision)



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source