Snowflake
Query and administer Snowflake through the SQL API, including DDL/DML, asynchronous statements, partitioned results, and cancellation.
Tools15
snowflake__execute_queryFreeExecute one SQL statement that begins with SELECT/SHOW/DESCRIBE/EXPLAIN and return its first result partition plus partition metadata. The check is on the leading keyword only — a SELECT that invokes a system function or stored procedure can still have effects, so this is not a read-only tool.Execute one SQL statement that begins with SELECT/SHOW/DESCRIBE/EXPLAIN and return its first result partition plus partition metadata. The check is on the leading keyword only — a SELECT that invokes a system function or stored procedure can still have effects, so this is not a read-only tool.
snowflake__execute_statementFreeExecute arbitrary Snowflake SQL, including DDL/DML and multi-statement requests. Snowflake warehouse charges may apply.Execute arbitrary Snowflake SQL, including DDL/DML and multi-statement requests. Snowflake warehouse charges may apply.
snowflake__get_statementFreeGet statement status or its first result partition by handle.Get statement status or its first result partition by handle.
snowflake__get_result_partitionFreeFetch one result partition for a completed statement.Fetch one result partition for a completed statement.
snowflake__cancel_statementFreeCancel a running SQL statement by handle.Cancel a running SQL statement by handle.
snowflake__list_databasesFreeList databases visible to the token role.List databases visible to the token role.
snowflake__list_warehousesFreeList warehouses visible to the token role.List warehouses visible to the token role.
snowflake__list_rolesFreeList roles visible to the token role.List roles visible to the token role.
snowflake__list_usersFreeList users visible to the token role.List users visible to the token role.
snowflake__list_schemasFreeList schemas in a database.List schemas in a database.
snowflake__list_tablesFreeList tables in a database schema.List tables in a database schema.
snowflake__list_viewsFreeList views in a database schema.List views in a database schema.
snowflake__list_stagesFreeList stages in a database schema.List stages in a database schema.
snowflake__list_tasksFreeList tasks in a database schema.List tasks in a database schema.
snowflake__describe_tableFreeDescribe the columns of a table.Describe the columns of a table.