Aident logoAident logo centerAident Loadout
Use CasesPricingDocs
ENStart Now
AppsSnowflake ToolsSnowflake Show Schemas
Snowflake Tools

Snowflake Show Schemas

Lists all schemas for which you have access privileges. Shows schema metadata including name, creation date, owner, database, retention time, and more. Can filter results and include dropped schemas within Time Travel retention period.

Write actionRisk level 2 of 5API key connection
Use Snowflake Show Schemas

Pricing and limits

Aident logo

Product

Aident LoadoutAident Playbook EditorOpen-CUAK

About

AppsSkillsUse CasesDocsBlogPricingDownloadsPrivacy PolicyTerms of Service

Alternatives

vs Composiovs Zapier
llms.txtGet an AI summary of Aident LoadoutSummarize with ChatGPTSummarize with ClaudeSummarize with GeminiSummarize with Perplexity

© Aident Labs, 2024-2026

Pricing
Free
Unified payment
Not currently supported

Inputs

  • rolestring
    Role to use when executing the statement.
  • limitinteger
    Maximum number of rows to return. Cannot exceed 10000.
  • terseboolean
    If true, returns only a subset of output columns (created_on, name, kind, database_name, schema_name).
  • historyboolean
    If true, includes dropped schemas that are still within Time Travel retention period.
  • timeoutinteger
    Timeout in seconds for statement execution.
  • databasestring
    Database context for the query.
  • in_scopestring
    Scope for the command. Options: 'ACCOUNT', 'DATABASE', or a specific database name.
  • from_namestring
    Used with LIMIT for pagination. Returns results starting from schemas whose names match this string.
  • warehousestring
    Warehouse to use for the query (though SHOW SCHEMAS doesn't require a running warehouse).
  • starts_withstring
    Filters results by schemas whose names start with this string. Case-sensitive.
  • like_patternstring
    Filters results by schema name using SQL wildcard pattern (% and _). Case-insensitive.

Observable output

  • data
    Required
    Data from the action execution
  • errorstring
    Error if any occurred during the execution of the action
  • successfulboolean
    Required
    Whether or not the action execution was successful or not

Skills that use this Action

Related use cases

No verified related use cases are linked yet.

Official source

Provider source

Skills that use this Action

No published Skills explicitly reference this Action yet.