Tool Low Events

The tool_low_events mart presents periods of low event volume for tools. This mart is dependent on the tool_usage_metrics_archive mart, filtering for periods of low event volume for a tool based on the low_events_flag field. If the tool is flagged as having low events for at least one hour, the occurrence is included in the tool_low_events mart. This mart is updated hourly.

BQ Prod Dataset Locations

  • mart_general

Interactive Mart Dependency Diagram

The following visualization shows the construction of this data mart defined in the UDP marts repository. More information on the repository and diagram can be found on this marts page.

mart_general.tool_low_events

Schema

mart/general/tool_low_events

Field name
Type
Description

ed_app_id

STRING

The EdApp ID of the tool.

ed_app_reporting

STRING

The reporting name for the EdApp ID, i.e. Canvas or Kaltura.

start_run_hour

DATETIME

The first hour the tool was flagged as having low event counts for a period of low events.

end_run_hour

DATETIME

The last hour the tool was flagged as having low event counts for a period of low events.

num_hours

INTEGER

The number of hours the period of low events occurred for the tool.

is_ongoing

BOOLEAN

If the period of low events for the tool is still ongoing as of the current hour.

Last updated