# 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](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/tool-usage-metrics/tool-usage-metrics-archive.md) 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 <a href="#user-content-schema" id="user-content-schema"></a>

The following visualization shows the construction of this data mart defined in the [UDP marts](https://gitlab.com/unizin-community/unizin-data-platform/marts) repository. More information on the repository and diagram can be found on [this marts page](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts.md).

{% hint style="info" %}
[Click here to open the interactive chart.](https://assets.public.unizin.org/udp-marts/mart/mart__general__tool_low_events.svg)
{% endhint %}

<figure><img src="/files/ot6SkJs6FWcHWkIzj5Uw" alt=""><figcaption><p>mart_general.tool_low_events</p></figcaption></figure>

## Schema <a href="#user-content-schema" id="user-content-schema"></a>

### **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.          |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/tool-usage-metrics/tool-low-events.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.