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

Snowflake Show Tables

Lists all tables for which you have access privileges. Shows table metadata including name, creation date, owner, database, schema, row count, size in bytes, clustering keys, and more. Can filter results and include dropped tables within Time Travel retention period.

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

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).
  • schemastring
    Schema context for the query.
  • historyboolean
    If true, includes dropped tables 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', 'SCHEMA', or specific database/schema names.
  • from_namestring
    Used with LIMIT for pagination. Returns results starting from tables whose names match this string.
  • warehousestring
    Warehouse to use for the query (though SHOW TABLES doesn't require a running warehouse).
  • starts_withstring
    Filters results by tables whose names start with this string. Case-sensitive.
  • like_patternstring
    Filters results by table 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.