Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Analyze your production issue on Firebase Crash...

Analyze your production issue on Firebase Crashlytics more efficient with BigQuery

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

Firebase Thailand

April 01, 2023
Tweet

More Decks by Firebase Thailand

Other Decks in Technology

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. Gain contextual insight into your crashes Never miss a critical

    crash Integrates with your existing workflows
  3. BigQuery Sandbox No access to streaming, data transfer, and data

    manipulation language statements Default table expiration time of 60 days No credit card needed
  4. • 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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