Skip to content

Instantly share code, notes, and snippets.

@sbrissenden

sbrissenden/crashes.sql

Created May 7, 2019 22:29
Show Gist options
  • Save sbrissenden/5289ca2221dabfe0247ca7497f400ed6 to your computer and use it in GitHub Desktop.
Save sbrissenden/5289ca2221dabfe0247ca7497f400ed6 to your computer and use it in GitHub Desktop.
Download ZIP
[BigQuery + Firebase Crashlytics] Crashes from May 9th
Raw
crashes.sql
#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