DIM_CLIENT_DETAILS
Updated
DIM_CLIENT_DETAILS is a dimension table that stores core metadata and configuration information for clients, including identification attributes, domain details, partner associations, client-specific properties, and lifecycle timestamps. It supports client-level analysis, configuration management, and reporting across the platform. Below are some of the scenarios where this Report is beneficial:
Client Configuration and Governance Management: Track client-specific configurations, properties, partner associations, and lifecycle changes to support administration, auditing, and governance across the platform.
Client-Level Reporting and Segmentation: Analyze operational and business metrics by client using client attributes, domains, and custom properties to enable meaningful segmentation and performance comparisons.
Partner and Account Relationship Analysis: Leverage client and partner association data to understand organizational relationships, support account management, and drive strategic business insights.
Field Mapping/ Glossary
The report will include the following information:
Expected Name | Definition | Data Type | Nullable & Default Value | PII Field | Unique Key |
CLIENT_ID | Unique identifier of the client or tenant | VARCHAR | No | No | Yes |
CLIENT_DNS | DNS or domain information associated with the client account | VARCHAR | No | No | No |
CLIENT_NAME | Official name of the client organization | VARCHAR | No | No | No |
CLIENT_PROPERTIES | JSON/variant object containing additional client-specific configuration and attributes Format: "Field1": ["Field 2": "Field Value"] |
VARIANT |
No |
No |
No |
CREATED_TIMESTAMP | Timestamp indicating when the client record was created | TIMESTAMP_LTZ | No | No | No |
IS_DELETED_FLAG | Flag indicating whether the client record has been soft-deleted Values: TRUE/FALSE |
BOOLEAN |
No |
No |
No |
MODIFIED_TIMESTAMP | Timestamp indicating when the client record was last modified | TIMESTAMP_LTZ | No | No | No |
PARTNER_ID | Identifier of the partner associated with the client | VARCHAR | No | 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.