Analyze your
Production Issue on
Firebase Crashlytics More
Efficient with BigQuery
Google Developer Expert in Android
Somkiat Khitwongwattana
Firebase Dev Day 2023
GDG Bangkok
Firebase Thailand
Organized by
Slide 2
Slide 2 text
Firebase
Crashlytics
Slide 3
Slide 3 text
Firebase
Crashlytics
Track, prioritize, and
fix crashes faster
Slide 4
Slide 4 text
Gain
contextual
insight into
your crashes
Never miss a
critical crash
Integrates with
your existing
workflows
Slide 5
Slide 5 text
No content
Slide 6
Slide 6 text
No content
Slide 7
Slide 7 text
No content
Slide 8
Slide 8 text
No content
Slide 9
Slide 9 text
No content
Slide 10
Slide 10 text
No content
Slide 11
Slide 11 text
Google Cloud
BigQuery
Slide 12
Slide 12 text
Google
Cloud
BigQuery
Cloud data
warehouse to power
your data-driven
innovation
Slide 13
Slide 13 text
No content
Slide 14
Slide 14 text
No content
Slide 15
Slide 15 text
Get more actionable insights
Deeper data exploration with
more customizebility
Decide how long to keep raw
data history
Slide 16
Slide 16 text
Querying data
No Cost Cost
Loading
Exporting
Storing data
Streaming inserts
Slide 17
Slide 17 text
Firebase
Spark Plan Sandbox
BigQuery
Slide 18
Slide 18 text
BigQuery
Sandbox
No access to streaming, data
transfer, and data manipulation
language statements
Default table expiration time of
60 days
No credit card needed
Slide 19
Slide 19 text
Firebase
Blaze Plan
Crashlytics
Streaming
Slide 20
Slide 20 text
● Comes automatically when
integrate Crashlytics with
BigQuery
● Data gets exported once daily
● Can provide backfilled data
up to 90 days prior
Ideal for long-term analysis
and identifying trends
overtime
● Only created when streaming
is enabled
● Data exported in real time
● No backfill available
Ideal for live dashboards and
custom alerts
Batch Table Realtime Table
Slide 21
Slide 21 text
Batch Table
Realtime Table
Slide 22
Slide 22 text
No content
Slide 23
Slide 23 text
Swipe right to
demo
Slide 24
Slide 24 text
event_id
issue_id
error_type
event_timestamp
Firebase Crashlytics’ Field
General
A unique ID for the event
An issue associated with the event
Error type of the event
When the event occurred
Slide 25
Slide 25 text
device
device.manufacturer
device.model
device.architecture
Firebase Crashlytics’ Field
Device
The device the event occurred on
The device manufacturer
The device model
The device architecture
Slide 26
Slide 26 text
application
application.build_version
application.display_version
Firebase Crashlytics’ Field
Application
The app that generated the event
The app's build version
The app's version name
Slide 27
Slide 27 text
user
user.name
user.email
user.id
Firebase Crashlytics’ Field
User
Info collected on the app's user
The user's name
The user's email address
An app-specific ID associated with the user
Slide 28
Slide 28 text
custom_keys
custom_keys.key
custom_keys.value
Firebase Crashlytics’ Field
Custom Keys
Developer-defined key-value pairs
A developer-defined key
A developer-defined value
Slide 29
Slide 29 text
logs
logs.timestamp
logs.message
Firebase Crashlytics’ Field
Logs
Log messages generated by logger
When the log was made
The logged message
Slide 30
Slide 30 text
blame_frame
blame_frame.line
blame_frame.file
The frame identified as the root cause of crash
The line number of the file of the frame
The name of the frame file
Firebase Crashlytics’ Field
Blame Frame
Slide 31
Slide 31 text
exceptions
exceptions.type
exceptions.title
exceptions.subtitle
Firebase Crashlytics’ Field
Exception (Android)
Exceptions that occurred during this event
The exception type, e.g. IllegalStateException
The subtitle of the thread
The subtitle of the thread
Slide 32
Slide 32 text
error
error.code
error.title
error.subtitle
Firebase Crashlytics’ Field
Error (iOS)
Non-fatal errors
Error code
The title of the thread
The subtitle of the thread
Slide 33
Slide 33 text
Swipe right to
demo again
Slide 34
Slide 34 text
BigQuery
Firebase Looker
Studio
Slide 35
Slide 35 text
Storage
The first 10 GB per month is free
Free Usage Tier
BigQuery
Queries
The first 1 TB of query data processed per month is free
BI Engine
Up to 1 GB of free capacity for Looker Studio users
Slide 36
Slide 36 text
Upgrade from Sandbox
● Still have access to no-cost tiers include in Sandbox but
operating beyond limits can incur changes
● Charges depend on how much data you store and queries
made
● Loading and exporting data is free
● No longer have 60-day expiry limit on tables but still need to
manually set expiration when upgrading
Slide 37
Slide 37 text
Additional Resources
Export Firebase Crashlytics data to BigQuery
bit.ly/fdd2023-crashlytics-bigquery
Google Cloud BigQuery
bit.ly/fdd2023-bigquery
BigQuery and Firebase: Integration and Streaming
bit.ly/fdd2023-firebase-bigquery-integration-post
Slide 38
Slide 38 text
Thank you
Somkiat Khitwongwattana
@akexorcist
Firebase Dev Day 2023