Documentation Index Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
Use this file to discover all available pages before exploring further.
Server path: /snowflake | Type: Application | PCID required: YesTool Description snowflake_execute_statementExecute a SQL statement in Snowflake and return results snowflake_check_statement_statusCheck the status of a previously submitted SQL statement snowflake_cancel_statementCancel the execution of a running SQL statement snowflake_list_databasesList all databases available in the Snowflake account snowflake_list_schemasList all schemas in a database or current database snowflake_list_tablesList all tables in a schema, database, or current context snowflake_describe_tableGet detailed information about a table including columns, data types, and constraints snowflake_get_table_ddlGet the DDL (Data Definition Language) statement for creating a table snowflake_get_warehouse_statusGet the status of warehouses (running, suspended, etc.) snowflake_start_warehouseStart a suspended warehouse snowflake_stop_warehouseStop/suspend a running warehouse snowflake_get_session_infoGet current session information including user, role, warehouse, database, and schema snowflake_get_query_historyGet query execution history with optional filters snowflake_get_usersGet a list of users in the Snowflake account
snowflake_execute_statement Execute a SQL statement in Snowflake and return results
Parameters: Parameter Type Required Default Description statementstring Yes — SQL statement to execute timeoutnumber No — Execution timeout in seconds (default: 60) bindingsobject No — Parameter bindings for the SQL statement databasestring No — Database context for the statement schemastring No — Schema context for the statement warehousestring No — Warehouse context for the statement rolestring No "ACCOUNTADMIN"Role context for the statement, defaults to ACCOUNTADMIN requestIdstring No — Optional request ID for tracking
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "statement" : { "type" : "string" , "description" : "SQL statement to execute" }, "timeout" : { "type" : "number" , "description" : "Execution timeout in seconds (default: 60)" }, "bindings" : { "type" : "object" , "additionalProperties" : true , "description" : "Parameter bindings for the SQL statement" }, "database" : { "type" : "string" , "description" : "Database context for the statement" }, "schema" : { "type" : "string" , "description" : "Schema context for the statement" }, "warehouse" : { "type" : "string" , "description" : "Warehouse context for the statement" }, "role" : { "type" : "string" , "default" : "ACCOUNTADMIN" , "description" : "Role context for the statement, defaults to ACCOUNTADMIN" }, "requestId" : { "type" : "string" , "description" : "Optional request ID for tracking" } }, "required" : [ "PCID" , "statement" ] }
snowflake_check_statement_status Check the status of a previously submitted SQL statement
Parameters: Parameter Type Required Default Description statementHandlestring Yes — Statement handle returned from execute_statement requestIdstring No — Optional request ID for tracking
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "statementHandle" : { "type" : "string" , "description" : "Statement handle returned from execute_statement" }, "requestId" : { "type" : "string" , "description" : "Optional request ID for tracking" } }, "required" : [ "PCID" , "statementHandle" ] }
snowflake_cancel_statement Cancel the execution of a running SQL statement
Parameters: Parameter Type Required Default Description statementHandlestring Yes — Statement handle of the statement to cancel requestIdstring No — Optional request ID for tracking
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "statementHandle" : { "type" : "string" , "description" : "Statement handle of the statement to cancel" }, "requestId" : { "type" : "string" , "description" : "Optional request ID for tracking" } }, "required" : [ "PCID" , "statementHandle" ] }
snowflake_list_databases List all databases available in the Snowflake account
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" } }, "required" : [ "PCID" ] }
snowflake_list_schemas List all schemas in a database or current database
Parameters: Parameter Type Required Default Description databasestring No — Database name to list schemas from (defaults to current database)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "database" : { "type" : "string" , "description" : "Database name to list schemas from (defaults to current database)" } }, "required" : [ "PCID" ] }
snowflake_list_tables List all tables in a schema, database, or current context
Parameters: Parameter Type Required Default Description databasestring No — Database name (defaults to current database) schemastring No — Schema name (defaults to current schema)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "database" : { "type" : "string" , "description" : "Database name (defaults to current database)" }, "schema" : { "type" : "string" , "description" : "Schema name (defaults to current schema)" } }, "required" : [ "PCID" ] }
snowflake_describe_table Get detailed information about a table including columns, data types, and constraints
Parameters: Parameter Type Required Default Description tableNamestring Yes — Name of the table to describe databasestring Yes — Database name schemastring Yes — Schema name
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "tableName" : { "type" : "string" , "description" : "Name of the table to describe" }, "database" : { "type" : "string" , "description" : "Database name" }, "schema" : { "type" : "string" , "description" : "Schema name" } }, "required" : [ "PCID" , "tableName" , "database" , "schema" ] }
snowflake_get_table_ddl Get the DDL (Data Definition Language) statement for creating a table
Parameters: Parameter Type Required Default Description tableNamestring Yes — Name of the table to get DDL for databasestring No — Database name (defaults to current database) schemastring No — Schema name (defaults to current schema)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "tableName" : { "type" : "string" , "description" : "Name of the table to get DDL for" }, "database" : { "type" : "string" , "description" : "Database name (defaults to current database)" }, "schema" : { "type" : "string" , "description" : "Schema name (defaults to current schema)" } }, "required" : [ "PCID" , "tableName" ] }
snowflake_get_warehouse_status Get the status of warehouses (running, suspended, etc.)
Parameters: Parameter Type Required Default Description warehouseNamestring No — Specific warehouse name (defaults to all warehouses)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "warehouseName" : { "type" : "string" , "description" : "Specific warehouse name (defaults to all warehouses)" } }, "required" : [ "PCID" ] }
snowflake_start_warehouse Start a suspended warehouse
Parameters: Parameter Type Required Default Description warehouseNamestring Yes — Name of the warehouse to start
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "warehouseName" : { "type" : "string" , "description" : "Name of the warehouse to start" } }, "required" : [ "PCID" , "warehouseName" ] }
snowflake_stop_warehouse Stop/suspend a running warehouse
Parameters: Parameter Type Required Default Description warehouseNamestring Yes — Name of the warehouse to stop
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "warehouseName" : { "type" : "string" , "description" : "Name of the warehouse to stop" } }, "required" : [ "PCID" , "warehouseName" ] }
snowflake_get_session_info Get current session information including user, role, warehouse, database, and schema
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" } }, "required" : [ "PCID" ] }
snowflake_get_query_history Get query execution history with optional filters
Parameters: Parameter Type Required Default Description limitnumber No — Maximum number of queries to return (default: 100) startTimestring No — Start time for query history (ISO format) endTimestring No — End time for query history (ISO format)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" }, "limit" : { "type" : "number" , "description" : "Maximum number of queries to return (default: 100)" }, "startTime" : { "type" : "string" , "description" : "Start time for query history (ISO format)" }, "endTime" : { "type" : "string" , "description" : "End time for query history (ISO format)" } }, "required" : [ "PCID" ] }
snowflake_get_users Get a list of users in the Snowflake account
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID for authentication" } }, "required" : [ "PCID" ] }
