# Usage Statistics

{% hint style="info" %}

#### Usage Statistics

**Usage Statistics** is a Data Catalog feature that tracks how often database entities are read, written to, or modified in the Business Intelligence Database (BIDB).

**Key Benefits:**

* Provides visibility into data consumption patterns
* Identifies most frequently accessed entities
* Enables resource optimization and impact analysis
* Creates audit trails for governance

**Database Support:**

* **Microsoft SQL & Oracle**: Requires database auditing to be manually enabled
* **Snowflake**: Works automatically without additional configuration

**How It Works:** The Entity Usage Worker job collects usage metrics from the audit database and stores them in the Entity Usage Statistic View within the BIDB, where they can be analyzed using third-party BI tools.
{% endhint %}

1. Click the Usage Statistics tile.

<figure><img src="https://1051758685-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fw1qJj4OGmdcvowiklB9W%2Fuploads%2FbKa9njQiteUKJSpTdjUx%2Fimage.png?alt=media&#x26;token=4621e2f9-230e-4777-a71f-cf636b9d46ff" alt=""><figcaption><p>Usage Statistics</p></figcaption></figure>

The Usage Statistics page opens with the following additional options to configure data profiling.

{% hint style="warning" %}
Configure the path to: /var/opt/mssql/data - you will need to map the path / volume.
{% endhint %}

<figure><img src="https://1051758685-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fw1qJj4OGmdcvowiklB9W%2Fuploads%2F6YFFGMlDgPVVgvG17iax%2Fimage.png?alt=media&#x26;token=56e00440-f4d7-4920-9569-98fc89d7da12" alt=""><figcaption><p>Configure Usage Statistics</p></figcaption></figure>

{% hint style="info" %}
Additionally, you can also view certain usage-related properties in the Properties panel of the Summary tab in Data Canvas. The properties displayed may vary depending on the selected data asset.
{% endhint %}

<figure><img src="https://1051758685-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fw1qJj4OGmdcvowiklB9W%2Fuploads%2FxY8QUxfppJhGxciiiWHA%2Fimage.png?alt=media&#x26;token=1092c8f4-30d3-49ae-b83d-7a378839ce05" alt=""><figcaption></figcaption></figure>

***
