Skip to content

Instantly share code, notes, and snippets.

@seyhunak
Forked from sbrissenden/crashes.sql
Created August 31, 2021 19:23
Show Gist options
  • Save seyhunak/d8b260ebea2161f7bf17a4e7a93074f4 to your computer and use it in GitHub Desktop.
Save seyhunak/d8b260ebea2161f7bf17a4e7a93074f4 to your computer and use it in GitHub Desktop.
[BigQuery + Firebase Crashlytics] Crashes from May 9th
#standardSQL
SELECT
event_id, issue_id, blame_frame.file, blame_frame.line
FROM
`projectId.firebase_crashlytics.package_name_ANDROID`
WHERE
FORMAT_TIMESTAMP("%Y%m%d", TIMESTAMP_TRUNC(event_timestamp, DAY)) = '20190509'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment