LogRocket Events Table Schema

Event Schema

Format of landed data

Data warehouses & databases (incl. Snowflake, BigQuery, Redshift, Databricks)

Data transferred to data warehouses and relational databases will be loaded as properly typed tables within a single schema.

In addition, a special _transfer_status table will be loaded in the created schema to record transfer metadata, namely, a transfer_last_updated_at timestamp for each table.

Object storage (incl. AWS S3, Google Cloud Storage, Azure Blob Storage)

Data transferred to object storage destinations will be loaded as Apache Parquet files in Apache Hive style partitions. This means data will appear in the following folder structure:

\<bucket_name>/\<folder_name>/logrocket_events/dt=\<transfer_date>/\<transfer_timestamp>.parquet

Where:

• \<bucket_name> and \<folder_name> are provided during destination configuration.
• logrocket_events is the name of the data model being transferred (this is equivalent to a table name in relational data destinations).
• \<transfer_date> and \<transfer_timestamp> are generated at transfer time.

Spreadsheets (incl. Google Sheets)

Data transferred to spreadsheet destinations will be loaded as a newly created tab per data model. Where possible, the tabs will be created as protected tabs (or "read-only") to prevent accidental modification.

Comparison of original data export data to the Streaming Data Export

Old to new schema mappings

Below is a mapping of the old event types to their corresponding column prefixes in the new streaming data export schema. The specific fields will be translated from camel case to snake case.

Example event names translated to column names

For example, the metadata event below would have the following columns:

{
  "type": "lr.Metadata",
  "seqID": 9,
  "time": 1681406759856,
  "tabID": "911d320a-ab31-4b80-9f11-1c5ec1af5e59",
  "data": {
    "release": "48fc3710a6e3a02c0876f8a456ea8b5deeee34b5",
    "sdkVersion": "script",
    "scriptVersion": "16.265.0",
    "country": "United States",
    "region": "Virginia",
    "city": "Ashburn",
    "browserInfo": {
      "href": "https://staging.logrocket.com/pingdom/test",
      "codeName": "Mozilla",
    },
  }

Corresponding column names:

• session_release
• session_sdk_version
• session_script_version
• session_country
• session_region
• session_city
• session_browser_info_href
• session_browser_info_code_name

Data discrepancies by event type

The following fields for each event type are not present in the new data export stream but were present in the original version of data export.

lr.browser.NavigationEvent

• type

lr.Metadata

• userFingerprint
• sdkVersion
• sdkOptions
• scriptVersion
• scriptSrc
• replayType
• release
• latitude
• longitude
• isInactive
• timeToFirstByte
• initialPageLoadTime
• isLocalhost

lr.network.RequestEvent

This event type does not exist in the new data export stream.

lr.core.Exception

• eventId
• groupId
• culprit
• filename
• message
• eventMessage
• exceptionType
• exceptionValue
• groupHash
• href