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

Snowflake Show Databases

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

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

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 databases that are still within Time Travel retention period.
  • timeoutinteger
    Timeout in seconds for statement execution.
  • from_namestring
    Used with LIMIT for pagination. Returns results starting from databases whose names match this string.
  • warehousestring
    Warehouse to use for the query (though SHOW DATABASES doesn't require a running warehouse).
  • starts_withstring
    Filters results by databases whose names start with this string. Case-sensitive.
  • like_patternstring
    Filters results by database 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.