Cohort Role Analysis
Analyze roles accessible to Snowflake users within a specified cost center.
Last updated
Was this helpful?
Analyze roles accessible to Snowflake users within a specified cost center.
Last updated
Was this helpful?
Was this helpful?
Early Access: This API is provided in Early Access. Please contact our customer support team for more information and to enable this feature.
The Cohort Role Analysis API provides insights into role accessibility for Snowflake users within a specified cost center. It identifies which roles are accessible to users in that cost center and orders them by least privilege, helping to establish common access patterns and standardize role assignments. The response includes:
A list of roles accessible to users in the cost center
An indication of whether these roles are accessible to all users or only some users in the cost center
The API first attempts to find roles that are accessible to all principals (users) in the cost center. If no roles are accessible to all principals, it falls back to returning roles that are accessible by at least one principal, indicated by the accessibility_type field in the response.
This API can help organizations understand common access patterns within organizational units and can support role standardization efforts:
Role Standardization: Identify common roles used within organizational units
Access Pattern Analysis: Discover shared access patterns among users in the same cost center
Least Privilege Implementation: Find roles that provide necessary access with minimal permissions
Onboarding Planning: Determine appropriate roles for new hires based on their cost center
This feature is currently limited to the Snowflake integration.
Role analysis is based on cost center information, which must be properly configured in your system.
OK
Default error response
POST /api/private/assessments/cohort_role_analysis HTTP/1.1
Host: your-tenant.cookiecloud.ai
Authorization: Bearer JWT
Content-Type: application/json
Accept: */*
Content-Length: 32
{
"cost_center": "text",
"limit": 1
}{
"grantee_ids": [
"text"
],
"accessibility_type": 1
}The API accepts a request object with the following parameters:
cost_center
string
Yes
The identifier for the cost center whose roles should be analyzed
limit
uint32
No
The maximum number of roles to return (defaults to 5 if not specified)
The API uses the following protocol buffer message definitions:
message CohortRoleAnalysisRequest {
string cost_center = 1;
uint32 limit = 2;
}
enum GranteeAccessibility {
ALL_PRINCIPALS = 0; // Grantees accessible from all principals
ANY_PRINCIPAL = 1; // Grantees accessible from at least one principal
}
message CohortRoleAnalysisResponse {
repeated string grantee_ids = 1;
GranteeAccessibility accessibility_type = 2;
}The API returns a response object with the following fields:
grantee_ids
string[]
A list of role IDs that are accessible to users in the specified cost center
accessibility_type
GranteeAccessibility
Indicates whether roles were accessible to all principals or any principal
The accessibility_type field can have one of the following values:
ALL_PRINCIPALS
Roles accessible from all principals in the cost center
ANY_PRINCIPAL
Roles accessible from at least one principal in the cost center
Note: If no roles are accessible to all principals in the cost center, the API falls back to returning roles accessible by any principal, and the accessibility_type will be set to ANY_PRINCIPAL.
Request
{
"cost_center": "CC-SALES",
"limit": 5
}Response
The response indicates these roles are accessible to all users in the cost center:
{
"grantee_ids": [
"example-snowflake.com/role/WORKSPACE_LOGS_ROLE",
"example-snowflake.com/role/DATA_LINEAGE_READONLY_ROLE",
"example-snowflake.com/role/WAREHOUSE_USER_ROLE"
],
"accessibility_type": "ALL_PRINCIPALS"
}Request
{
"cost_center": "CC-MARKETING"
}Response
The response indicates no roles are accessible to all users, but these roles are accessible to at least one user in the cost center:
{
"grantee_ids": [
"example-snowflake.com/role/MARKETING_PARTNER_READONLY_ROLE",
"example-snowflake.com/role/MARKETING_ENTERPRISE_READONLY_ROLE",
"example-snowflake.com/role/WORKSPACE_LOGS_ROLE",
"example-snowflake.com/role/MARKETING_PRODUCT_READONLY_ROLE",
"example-snowflake.com/role/MARKETING_UTILS_READONLY_ROLE"
],
"accessibility_type": "ANY_PRINCIPAL"
}