DIM_DATA_RESOURCE
Updated
The DIM_DATA_RESOURCE dimension table provides a centralized reference for assets and their associated metadata. It captures key attributes such as asset identifiers, type, descriptive properties, and event timestamps. Each record is uniquely identified for accurate tracking and auditing. This table is designed to support asset management, classification, and reporting across the platform. Below are some of the scenarios where this Report is beneficial:
Asset Management: Provide a centralized reference for assets with identifiers, types, and descriptive properties to ensure consistent handling.
Classification & Reporting: Capture event timestamps and metadata to support structured categorization and accurate reporting across the platform.
Audit & Tracking: Maintain uniquely identified records for reliable tracking, compliance, and operational transparency.
Field Mapping/ Glossary
The report will include the following information:
Expected Name | Definition | Data Type | Nullable/Default | Is PII Field? | Unique Key | Is Mutable? |
ASSET_ID | A unique identifier assigned to each asset for tracking and reference. | VARCHAR(16777216) | No | No | No |
|
ASSET_METADATA | Metadata or additional information describing the asset’s properties. | VARIANT | No | No | No |
|
ASSET_TYPE | The category or type of the asset, specifying its classification. | VARCHAR(16777216) | No | No | No |
|
EVENT_TIMESTAMP | The timestamp indicating when the event related to the asset occurred. | NUMBER(38,0) | No | No | No |
|
RECORD_ID | A unique identifier assigned to each event or record for identification purposes. | VARCHAR(16777216) | No | No | Yes |
|