Snowflake

Snowflake is a cloud data warehouse platform that enables data storage, processing, and analytics with scalable compute and storage resources.

Tools

Last Updated

Recently

Tools

Execute Query

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.

Execute Query Async

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 Query Status

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.

Get Query Results

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

Cancel Query

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

List Databases

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

List Schemas

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

List Tables

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.

Describe Table

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

Get Table Sample

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.

...

1–10 of 43 tools