Snowflake · Schema
Secret
A Snowflake secret
DataData WarehouseData LakehouseCloud Data PlatformAnalyticsArtificial IntelligenceData EngineeringData GovernanceSQLApache IcebergModel Context ProtocolT1
Properties
| Name | Type | Description |
|---|---|---|
| type | string | Type of the secret |
| comment | string | user comment associated to an object in the dictionary |
| name | string | Name of the secret |
| created_on | string | Date and time when the secret was created. |
| database_name | string | Database in which the secret is stored |
| schema_name | string | Schema in which the secret is stored |
| owner | string | Role that owns the secret |
| owner_role_type | string | The type of role that owns the secret |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"title": "Secret",
"type": "object",
"description": "A Snowflake secret",
"properties": {
"type": {
"type": "string",
"description": "Type of the secret"
},
"comment": {
"type": "string",
"description": "user comment associated to an object in the dictionary"
},
"name": {
"type": "string",
"pattern": "^\"([^\"]|\"\")+\"|[a-zA-Z_][a-zA-Z0-9_$]*$",
"description": "Name of the secret"
},
"created_on": {
"type": "string",
"format": "date-time",
"readOnly": true,
"description": "Date and time when the secret was created."
},
"database_name": {
"type": "string",
"pattern": "^\"([^\"]|\"\")+\"|[a-zA-Z_][a-zA-Z0-9_$]*$",
"readOnly": true,
"description": "Database in which the secret is stored"
},
"schema_name": {
"type": "string",
"pattern": "^\"([^\"]|\"\")+\"|[a-zA-Z_][a-zA-Z0-9_$]*$",
"readOnly": true,
"description": "Schema in which the secret is stored"
},
"owner": {
"type": "string",
"pattern": "^\"([^\"]|\"\")+\"|[a-zA-Z_][a-zA-Z0-9_$]*$",
"readOnly": true,
"description": "Role that owns the secret"
},
"owner_role_type": {
"type": "string",
"readOnly": true,
"description": "The type of role that owns the secret"
}
},
"required": [
"type",
"name"
],
"discriminator": {
"propertyName": "type",
"mapping": {
"PASSWORD": "PasswordSecret",
"OAUTH2": "Oauth2Secret",
"GENERIC_STRING": "GenericStringSecret",
"SYMMETRIC_KEY": "SymmetricKeySecret",
"CLOUD_PROVIDER_TOKEN": "CloudProviderTokenSecret",
"JWT_KEY_PAIR": "JwtKeyPairSecret"
}
}
}
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/secret-secret"
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.