Snowflake · Schema
Role
A Snowflake role
SnowflakeDataData WarehouseData LakehouseCloud Data PlatformAnalyticsArtificial IntelligenceData EngineeringData GovernanceSQLApache IcebergMCPT1
Properties
| Name | Type | Description |
|---|---|---|
| name | string | Name of the role. |
| comment | string | Comment of the role. |
| created_on | string | Date and time when the role was created. |
| owner | string | Specifies the role that owns this role. |
| is_default | boolean | Specifies whether the role being fetched is the user's default role. |
| is_current | boolean | Specifies whether the role being fetched is the user's current role. |
| is_inherited | boolean | Specifies whether the role used to run the command inherits the specified role. |
| assigned_to_users | integer | The number of users to whom this role has been assigned. |
| granted_to_roles | integer | The number of roles to which this role has been granted. |
| granted_roles | integer | The number of roles that have been granted to this role. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"title": "Role",
"type": "object",
"description": "A Snowflake role",
"properties": {
"name": {
"type": "string",
"description": "Name of the role."
},
"comment": {
"type": "string",
"description": "Comment of the role."
},
"created_on": {
"type": "string",
"description": "Date and time when the role was created."
},
"owner": {
"type": "string",
"description": "Specifies the role that owns this role."
},
"is_default": {
"type": "boolean",
"description": "Specifies whether the role being fetched is the user's default role."
},
"is_current": {
"type": "boolean",
"description": "Specifies whether the role being fetched is the user's current role."
},
"is_inherited": {
"type": "boolean",
"description": "Specifies whether the role used to run the command inherits the specified role."
},
"assigned_to_users": {
"type": "integer",
"description": "The number of users to whom this role has been assigned."
},
"granted_to_roles": {
"type": "integer",
"description": "The number of roles to which this role has been granted."
},
"granted_roles": {
"type": "integer",
"description": "The number of roles that have been granted to this role."
}
}
}
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/role-role"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.