Skip to main content
Glama

Snowflake List Dynamic Tables

snowflake_list_dynamic_tables
Read-only

List dynamic tables with lag targets, refresh mode, and last refresh status to monitor Snowflake pipeline health.

Instructions

List dynamic tables with lag targets, refresh mode, and last refresh status.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
patternNo
databaseNo
schema_nameNo

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed6 schema fields changedv1.2.0
    • addedInput schema / additionalProperties
      Added value: +false
    • removedInput schema / properties / database / title
      Removed value: -"Database"
    • removedInput schema / properties / pattern / title
      Removed value: -"Pattern"
    • removedInput schema / properties / schema_name / title
      Removed value: -"Schema Name"
    • removedInput schema / title
      Removed value: -"snowflake_list_dynamic_tablesArguments"
    • removedOutput schema / title
      Removed value: -"snowflake_list_dynamic_tablesDictOutput"
  2. First observedv0.1.0

TDQS

B3.4/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint=true, openWorldHint=true, and destructiveHint=false, so the safety profile is clear. The description adds useful context by naming some metadata fields returned, but it omits any auth, pagination, or scoping behavior beyond that.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single front-loaded sentence with no wasted words. It states the core action and supplemental output fields efficiently.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

An output schema exists and annotations cover the safety profile, so return values and safety need not be explained. However, the description lacks any filter semantics or usage context for the optional parameters, leaving it incomplete for correct invocation in a multi-sibling namespace.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, and the description does not mention the three optional filter parameters (pattern, database, schema_name) or how they constrain results. The parameter names are somewhat self-explanatory, but the description adds no meaning beyond the bare schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states a specific verb+resource ('List dynamic tables') and adds returned attributes ('lag targets, refresh mode, and last refresh status') that distinguish it from generic list_tables/list_views and from describe_dynamic_table. An agent can identify the resource and rough output without opening the schema.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No when-to-use guidance, prerequisites, or alternatives are provided. It does not say when to use this instead of describe_dynamic_table or list_tables, leaving selection entirely to the agent's inference.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server

Other Tools