Execute a SQL query synchronously in Snowflake. Returns results immediately for queries that complete within 45 seconds. Use this for quick queries, data exploration, and interactive analysis.

Submit a SQL query for asynchronous execution in Snowflake. Returns a statement handle immediately. Use this for long-running queries, large data operations, or when you need to execute multiple queries in parallel.

Check the execution status of an asynchronous query. Returns the current state (running, success, failed) and progress information. Use after submitting an async query to monitor its progress.

Retrieve the results of a completed asynchronous query. Returns the data rows and metadata. Use this after an async query has completed successfully.

Cancel a running query in Snowflake. Use this to stop long-running queries that are no longer needed or were submitted by mistake.

List all databases accessible to the current user in Snowflake. Returns database names, owners, and metadata. Useful for discovering available data sources.

List all schemas in a specific database. Returns schema names, owners, and metadata. Essential for navigating database structure and finding relevant data.

List all tables and views in a schema. Returns table names, types (TABLE/VIEW), row counts, and metadata. Critical for data discovery and understanding available datasets.

Get detailed information about a table's structure including column names, data types, nullability, defaults, and keys. Essential for understanding table schema before querying.

Retrieve sample rows from a table for quick data exploration. Returns a limited number of rows to understand data format and content without reading the entire table.