Analyze your production issue on Firebase Crashlytics more efficient with BigQuery

เพิ่มประสิทธิภาพในการวิเคราะห์ปัญหาจาก Firebase Crashlytics ด้วย BigQuery

Transcript

1. 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
2. Firebase Crashlytics
3. Firebase Crashlytics Track, prioritize, and fix crashes faster
4. Gain contextual insight into your crashes Never miss a critical crash Integrates with your existing workflows
11. Google Cloud BigQuery
12. Google Cloud BigQuery Cloud data warehouse to power your data-driven innovation
15. Get more actionable insights Deeper data exploration with more customizebility Decide how long to keep raw data history
16. Querying data No Cost Cost Loading Exporting Storing data Streaming inserts
17. Firebase Spark Plan Sandbox BigQuery
18. BigQuery Sandbox No access to streaming, data transfer, and data manipulation language statements Default table expiration time of 60 days No credit card needed
19. Firebase Blaze Plan Crashlytics Streaming
20. • 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
21. Batch Table Realtime Table
23. Swipe right to demo
24. 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
25. 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
26. 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
27. 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
28. 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
29. logs logs.timestamp logs.message Firebase Crashlytics’ Field Logs Log messages generated by logger When the log was made The logged message
30. 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
31. 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
32. 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
33. Swipe right to demo again
34. BigQuery Firebase Looker Studio
35. 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
36. 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
37. 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
38. Thank you Somkiat Khitwongwattana @akexorcist Firebase Dev Day 2023