DIM_MEDIA_ASSET_PROPERTY
Updated
The DIM_MEDIA_ASSET_PROPERTY table stores metadata and custom attributes related to media assets, including unique identifiers and modification timestamps. It helps manage and enrich media asset information, enabling advanced reporting, customization, and integration with workflows. Below are some of the scenarios where this Report is beneficial:
Media Asset Reporting and Segmentation: Use media asset metadata and custom attributes to categorize, filter, and analyze media assets for business-specific reporting and performance insights.
Asset Management and Governance: Track media asset identifiers and modification timestamps to maintain an audit trail, monitor updates, and ensure accurate asset management.
Workflow and Integration Enablement: Leverage media asset properties to enrich workflows, automate processes, and support integrations that rely on asset-specific metadata and custom fields.
Field Mapping/ Glossary
The report will include the following information:
Field Name | Definition | Data Type | Nullable & Default Value | PII Field | Unique Key |
ASSET_ID | Unique identifier of the asset associated with this record. | VARCHAR | Yes, NULL | No | Yes |
CUSTOM_PROPERTIES | Custom attributes and metadata related to the asset, stored as semi-structured JSON. Format: "CustomFieldID": ["Field Value"] |
VARIANT |
Yes, NULL |
No |
No |
RECORD_ID | Unique identifier for the record; serves as the primary key of the t | VARCHAR | Yes, NULL | No | No |
MODIFIED_TIMESTAMP | Epoch timestamp indicating when the record was last modified. | NUMBER | Yes, NULL | No | No |
Intended Use and Prohibited Uses
DataStream is intended solely to support operational efficiency, service delivery, business intelligence, and process optimisation. The product is not designed or intended for employee monitoring, workplace surveillance, performance evaluation, profiling of individuals, or making decisions that materially affect an individual's employment, rights, opportunities, or access to services.
DataStream does not process biometric data for the purpose of identifying individuals and does not perform emotion recognition, affect detection, or emotion inference in the workplace.
Customers must not use DataStream in a manner inconsistent with these intended purposes and remain responsible for ensuring compliance with applicable legal and regulatory requirements as well as with Sprinklr's Acceptable Use Policy.