Skip to content

Instantly share code, notes, and snippets.

@sbrissenden
Created May 7, 2019 22:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save sbrissenden/5289ca2221dabfe0247ca7497f400ed6 to your computer and use it in GitHub Desktop.
Save sbrissenden/5289ca2221dabfe0247ca7497f400ed6 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