COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Audience ID | VARCHAR(16777216) | Identifier for the audience (user group) | 123a12b3cd4e5f67g890h1ij | |
Audience Managers ID | VARCHAR(16777216) | User ID of the audience manager | 123a12b3cd4e5f67g890h1ij | |
Audience Managers Permissions | VARCHAR(16777216) | Audience manager permissions | null | |
Audience Name | VARCHAR(16777216) | Name of the audience | Sales North East | |
Audience Type | VARCHAR(16) | Flag to show if the audience is either an audience, direct or indirect | Direct Reports, Audiences, Indirect Reports | Direct Reports |
Content Privacy | VARCHAR(16777216) | Content privacy within the audience | private, public, null | private |
Created At | TIMESTAMP_NTZ(9) | Timestamp of audience creation | 2025-01-01T00:00:00.000+0000 | |
Doc Created At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Doc Updated At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Document Audience Type | VARCHAR(16777216) | Type of audience | smart, manual, null | smart |
Is Audience | BOOLEAN | Boolean indicator for audience) | TRUE, FALSE, null | TRUE |
People Managers ID | VARCHAR(16777216) | User ID of the people manager | 123a12b3cd4e5f67g890h1ij | |
People Managers Permissions | VARCHAR(16777216) | People manager permissions | null | |
Should Be Structure | BOOLEAN | Boolean indicator for structure (group of audiences = structure) | TRUE, FALSE, null | FALSE |
Structure ID | VARCHAR(16777216) | Identifier for the structure (group of audiences) | 123a12b3cd4e5f67g890h1ij | |
Structure Name | VARCHAR(16777216) | Name of the structure | Sales | |
Structure-Audience Name | VARCHAR(16777216) | Concatenation of the structure and audience names | Sales - Sales North East | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Updated At | TIMESTAMP_NTZ(9) | Timestamp of audience updates | 2025-01-01T00:00:00.000+0000 | |
User Sharing | VARCHAR(16777216) | User sharing information within the audience | audience, null, yes, no | yes |
DIM_AUDIENCE_SERVICE_AUDIENCES
- Updated on Sep 9, 2025
- Published on Sep 9, 2025
- 1 minute(s) read
Was this article helpful?