Blog Studio Go to console

    Dataset schema for exported data in BigQuery

    This page provides the dataset schema for exported Crashlytics data and Firebase sessions data in BigQuery .

    Firebase creates new datasets in BigQuery for your exported data:


    Crashlytics dataset

    Crashlytics data is exported into a BigQuery dataset named firebase_crashlytics . The dataset covers your entire project, even if it has multiple apps.

    Tables

    By default, Firebase creates individual tables inside the Crashlytics dataset for each app in your project that's linked to BigQuery .

    The tables are named based on the app's identifier (with periods converted to underscores) and appended with the app's platform ( _IOS or _ANDROID ). For example, data for an Android app with the package name com.google.test would be in a table named com_google_test_ANDROID .

    • If streaming export to BigQuery is enabled, then data will also be streamed in realtime to a table appended with _REALTIME (for example, com_google_test_ANDROID_REALTIME ).

    • Each row in a table represents an event that occurred in the app, including crashes, non-fatal errors, and ANRs.

    • The tables contain a standard set of Crashlytics data in addition to any custom Crashlytics keys defined by you in your app ( iOS+ | Android | Flutter | Unity ).

    Rows

    Each row in a table represents an error the app encountered.

    Columns

    The columns in a table are identical for crashes, non-fatal errors, and ANRs.

    • If streaming export to BigQuery is enabled, then the realtime table will have the same columns as the batch table.

    • You might have columns in rows that represent events that don't have stack traces.

    Here are the columns in the table for the exported Crashlytics data:

    Field name Data type Description
    app_orientation
    		STRING For example, PORTRAIT , LANDSCAPE , FACE_UP , FACE_DOWN , etc.
    application
    		RECORD The app that generated the event
    application.build_version
    		STRING The app's build version
    application.display_version
    		STRING
    blame_frame
    		RECORD The frame identified as the root cause of the crash or error
    blame_frame.address
    		INT64 The address in the binary image which contains the code
    Unset for Java frames
    blame_frame.blamed
    		BOOLEAN Whether Crashlytics determined that this frame is the cause of the crash or error
    blame_frame.file
    		STRING The name of the frame file
    blame_frame.library
    		STRING The display name of the library that includes the frame
    blame_frame.line
    		INT64 The line number of the file of the frame
    blame_frame.offset
    		INT64 The byte offset into the binary image that contains the code
    Unset for Java exceptions
    blame_frame.owner
    		STRING For example, DEVELOPER , VENDOR , RUNTIME , PLATFORM , or SYSTEM
    blame_frame.symbol
    		STRING The hydrated symbol, or raw symbol if it's unhydrateable
    breadcrumbs
    		REPEATED RECORD Timestamped Google Analytics breadcrumbs , if enabled
    breadcrumbs.name
    		STRING The name associated with the breadcrumb
    breadcrumbs.params
    		REPEATED RECORD Parameters associated with the breadcrumb
    breadcrumbs.params.key
    		STRING A parameter key associated with the breadcrumb
    breadcrumbs.params.value
    		STRING A parameter value associated with the breadcrumb
    breadcrumbs.timestamp
    		TIMESTAMP The timestamp associated with the breadcrumb
    bundle_identifier
    		STRING The unique identifier for the app as registered in the Firebase project (for example, com.google.gmail )
    For Apple platform apps, this is the bundle ID of the app.
    For Android apps, this is the package name of the app.
    crashlytics_sdk_versions
    		STRING The Crashlytics SDK version that generated the event
    custom_keys
    		REPEATED RECORD Developer-defined key-value pairs
    custom_keys.key
    		STRING A developer-defined key
    custom_keys.value
    		STRING A developer-defined value
    device
    		RECORD The device the event occurred on
    device_orientation
    		STRING For example, PORTRAIT , LANDSCAPE , FACE_UP , FACE_DOWN , etc.
    device.architecture
    		STRING For example, X86_32 , X86_64 , ARMV7 , ARM64 , ARMV7S , or ARMV7K
    device.manufacturer
    		STRING The device manufacturer
    device.model
    		STRING The device model
    error
    		REPEATED RECORD (Apple apps only) non-fatal errors
    error_type
    		STRING The error type of the event (for example, FATAL , NON_FATAL , ANR , etc.)
    error.blamed
    		BOOLEAN Whether Crashlytics determined that this frame is the cause of the error
    error.code
    		INT64 Error code associated with the app's custom logged NSError
    error.frames
    		REPEATED RECORD The frames of the stacktrace
    error.frames.address
    		INT64 The address in the binary image which contains the code
    error.frames.blamed
    		BOOLEAN Whether Crashlytics determined that this frame is the cause of the error
    error.frames.file
    		STRING The name of the frame file
    error.frames.library
    		STRING The display name of the library that includes the frame
    error.frames.line
    		INT64 The line number of the file of the frame
    error.frames.offset
    		INT64 The byte offset into the binary image that contains the code
    error.frames.owner
    		STRING For example, DEVELOPER , VENDOR , RUNTIME , PLATFORM , or SYSTEM
    error.frames.symbol
    		STRING The hydrated symbol, or raw symbol if it's unhydrateable
    error.queue_name
    		STRING The queue the thread was running on
    error.subtitle
    		STRING The subtitle of the thread
    error.title
    		STRING The title of the thread
    event_id
    		STRING The unique ID for the event
    event_timestamp
    		TIMESTAMP When the event occurred
    exceptions
    		REPEATED RECORD (Android only) Exceptions that occurred during this event. Nested exceptions are presented in reverse chronological order, which means that the last record is the first exception thrown
    exceptions.blamed
    		BOOLEAN True if Crashlytics determines the exception is responsible for the error or crash
    exceptions.exception_message
    		STRING A message associated with the exception
    exceptions.frames
    		REPEATED RECORD The frames associated with the exception
    exceptions.frames.address
    		INT64 The address in the binary image which contains the code
    Unset for Java frames
    exceptions.frames.blamed
    		BOOLEAN Whether Crashlytics determined that this frame is the cause of the crash or error
    exceptions.frames.file
    		STRING The name of the frame file
    exceptions.frames.library
    		STRING The display name of the library that includes the frame
    exceptions.frames.line
    		INT64 The line number of the file of the frame
    exceptions.frames.offset
    		INT64 The byte offset into the binary image that contains the code
    Unset for Java exceptions
    exceptions.frames.owner
    		STRING For example, DEVELOPER , VENDOR , RUNTIME , PLATFORM , or SYSTEM
    exceptions.frames.symbol
    		STRING The hydrated symbol, or raw symbol if it's unhydrateable
    exceptions.nested
    		BOOLEAN True for all but the last-thrown exception (meaning the first record)
    exceptions.subtitle
    		STRING The subtitle of the thread
    exceptions.title
    		STRING The title of the thread
    exceptions.type
    		STRING The exception type (for example, java.lang.IllegalStateException)
    firebase_session_id
    		STRING The automatically generated ID for the Firebase session mapped to the event from Crashlytics
    installation_uuid
    		STRING An ID that identifies a unique app and device installation
    is_fatal
    		BOOLEAN Whether the app crashed
    issue_id
    		STRING The issue associated with the event
    logs
    		REPEATED RECORD Timestamped log messages generated by the Crashlytics logger, if enabled
    logs.message
    		STRING The logged message
    logs.timestamp
    		TIMESTAMP When the log was made
    memory
    		RECORD The device's memory status
    memory.free
    		INT64 Bytes of memory remaining
    memory.used
    		INT64 Bytes of memory used
    operating_system
    		RECORD The details of the OS on the device
    operating_system.device_type
    		STRING The type of device (for example, MOBILE , TABLET , TV , etc.); also known as "device category"
    operating_system.display_version
    		STRING The version of the OS on the device
    operating_system.modification_state
    		STRING Whether the device has been modified (for example, a jailbroken app is MODIFIED and a rooted app is UNMODIFIED )
    operating_system.name
    		STRING The name of the OS on the device
    operating_system.type
    		STRING (Apple apps only) The type of OS running on the device (for example, IOS , MACOS , etc.)
    platform
    		STRING The platform of the app as registered in the Firebase project (valid values: IOS or ANDROID )
    process_state
    		STRING BACKGROUND or FOREGROUND
    storage
    		RECORD The device's persistent storage
    storage.free
    		INT64 Bytes of storage remaining
    storage.used
    		INT64 Bytes of storage used
    threads
    		REPEATED RECORD Threads present at the time of the event
    threads.blamed
    		BOOLEAN Whether Crashlytics determined that this frame is the cause of the crash or error
    threads.code
    		INT64 (Apple apps only) Error code of the application's custom logged NSError
    threads.crash_address
    		INT64 The address of the signal that caused the application to crash; only present on crashed native threads
    threads.crashed
    		BOOLEAN Whether the thread crashed
    threads.frames
    		REPEATED RECORD The frames of the thread
    threads.frames.address
    		INT64 The address in the binary image which contains the code
    threads.frames.blamed
    		BOOLEAN Whether Crashlytics determined that this frame is the cause of the error
    threads.frames.file
    		STRING The name of the frame file
    threads.frames.library
    		STRING The display name of the library that includes the frame
    threads.frames.line
    		INT64 The line number of the file of the frame
    threads.frames.offset
    		INT64 The byte offset into the binary image that contains the code
    threads.frames.owner
    		STRING For example, DEVELOPER , VENDOR , RUNTIME , PLATFORM , or SYSTEM
    threads.frames.symbol
    		STRING The hydrated symbol, or raw symbol if it's unhydreatable
    threads.queue_name
    		STRING (Apple apps only) The queue the thread was running on
    threads.signal_code
    		STRING The code of the signal that caused the app to crash; only present on crashed native threads
    threads.signal_name
    		STRING The name of the signal that caused the app to crash, only present on crashed native threads
    threads.subtitle
    		STRING The subtitle of the thread
    threads.thread_name
    		STRING The thread's name
    threads.title
    		STRING The title of the thread
    unity_metadata.debug_build
    		BOOLEAN If this is a debug build
    unity_metadata.graphics_copy_texture_support
    		STRING Support for copying graphics texture as defined in the Unity API
    unity_metadata.graphics_device_id
    		INT64 The identifier of the graphics device
    unity_metadata.graphics_device_name
    		STRING The name of the graphics device
    unity_metadata.graphics_device_type
    		STRING The type of the graphics device
    unity_metadata.graphics_device_vendor_id
    		INT64 The identifier of the graphics processor's vendor
    unity_metadata.graphics_device_vendor
    		STRING The vendor of the graphics device
    unity_metadata.graphics_device_version
    		STRING The version of the graphics device
    unity_metadata.graphics_max_texture_size
    		INT64 The maximum size dedicated to rendering texture
    unity_metadata.graphics_memory_size_mb
    		INT64 The graphics memory in MB
    unity_metadata.graphics_render_target_count
    		INT64 The number of graphical rendering targets
    unity_metadata.graphics_shader_level
    		INT64 The shader level of the graphics
    unity_metadata.processor_count
    		INT64 The number of processors (cores)
    unity_metadata.processor_frequency_mhz
    		INT64 The frequency of the processor(s) in MHz
    unity_metadata.processor_type
    		STRING The type of processor
    unity_metadata.screen_refresh_rate_hz
    		INT64 The refresh rate of the screen in Hz
    unity_metadata.screen_resolution_dpi
    		STRING The DPI of the screen as a floating point number
    unity_metadata.screen_size_px
    		STRING The size of the screen in pixels, formatted as width x height
    unity_metadata.system_memory_size_mb
    		INT64 The size of the system's memory in Mb
    unity_metadata.unity_version
    		STRING The version of Unity running on this device
    user
    		RECORD (Optional) Info collected about the app's user
    user.email
    		STRING (Optional) The user's email address
    user.id
    		STRING (Optional) An app-specific ID associated with the user
    user.name
    		STRING (Optional) The user's name
    variant_id
    		STRING The issue variant associated with this event
    Note that not all events have an associated issue variant.


    Firebase sessions dataset

    Firebase sessions data is exported into a BigQuery dataset named firebase_sessions . The dataset covers your entire project, even if it has multiple apps.

    Tables

    By default, Firebase creates individual tables inside the Firebase sessions dataset for each app in your project that's linked to BigQuery .

    The tables are named based on the app's identifier (with periods converted to underscores) and appended with the app's platform ( _IOS or _ANDROID ). For example, data for an Android app with the package name com.google.test would be in a table named com_google_test_ANDROID .

    Rows

    Each row in a table represents a session event that happened.

    Columns

    If streaming export to BigQuery is enabled, then the realtime table will have the same columns as the batch table.

    Here are the columns within the table for the exported Firebase sessions data:

    Field name Data type Description
    instance_id
    		STRING The Firebase installation ID (FID) from the device. Identifies a unique app + device installation
    session_id
    		STRING The unique ID of this session
    first_session_id
    		STRING The first ID of a series of sessions this session is in since the app was cold started. This can be used to group all sessions that have occurred since a cold start. If this session is the first session, this field will be the same as session_id .
    session_index
    		INTEGER The order this session came in after the app was cold started. For the first session after a cold start, this will be 0 . The index will be incremented every time a session is generated without a cold start occurring (for example, after 30 mins of inactivity).
    event_type
    		STRING The type of event that happened in the session (for example, SESSION_START )
    event_timestamp
    		TIMESTAMP The time of the event's occurrence
    received_timestamp
    		TIMESTAMP The time the event was received by the server from the device
    performance_data_collection_enabled
    		BOOLEAN Whether the Firebase Performance Monitoring SDK data collection was enabled at the time of the session
    crashlytics_data_collection_enabled
    		BOOLEAN Whether the Firebase Crashlytics SDK data collection was enabled at the time of the session
    application
    		RECORD Describes the application
    application.build_version
    		STRING The build version of the application (for example, 1523456 )
    application.display_version
    		STRING The display version of the application (for example, 4.1.7 )
    device
    		RECORD The device on which the event occurred
    device.model
    		STRING The model of the device
    device.manufacturer
    		STRING The manufacturer of the device. For Apple platform apps, this will be NULL .
    operating_system
    		RECORD Describes the OS of the device
    operating_system.display_version
    		STRING The display version of the operating system (for example, 10.2.1 )
    operating_system.name
    		STRING The name of the operating system
    operating_system.type
    		STRING The type of the operating system (for example, IOS ). This field is only set for Apple devices.
    operating_system.device_type
    		STRING The type of device (for example, MOBILE , TABLET , TV )
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: