Skip to main content

​
Overview

Snowflake allows to store and analyze data using cloud-based hardware and software. Through Langdock’s integration, you can access and manage Snowflake directly from your conversations.
Authentication: API Key Category: Data & Analytics Availability: All workspace plans

​
Available Actions

​
Execute SQL

snowflake.execute_sql
Execute SQL query and return resulting data Requires Confirmation: Yes Parameters:
  • sqlQuery (MULTI_LINE_TEXT, Required): The SQL query to execute against Snowflake
  • includeFullMetadata (BOOLEAN, Optional): If enabled, returns the complete raw Snowflake API response including all metadata. If disabled (default), returns only the query results as a clean array of objects
Output: Returns the operation result

​
Search schema

snowflake.search_schema
Searches for schemas or tables containing specific keywords Requires Confirmation: No Parameters:
  • searchQuery (TEXT, Required): The keyword to search for in schema or table names. For example, to find tables containing Salesforce data, search for ‘salesforce’
  • searchType (SELECT, Optional): What to search for: ‘table’ (default) searches for table names, ‘schema’ searches for schema names
  • includeFullMetadata (BOOLEAN, Optional): If enabled, returns the complete raw Snowflake API response including all metadata. If disabled (default), returns only the query results as a clean array of objects
Output: Returns the operation result
snowflake.cortex_search
Performs semantic search using Snowflake Cortex Search service Requires Confirmation: No Parameters:
  • searchServiceName (TEXT, Required): The name of the Cortex Search service to use (must be created beforehand in Snowflake)
  • query (TEXT, Required): The search query for semantic search. Cortex Search uses both vector and keyword methods to find relevant results
  • columns (TEXT, Optional): Comma-separated list of columns to return in the search results. If not specified, all columns are returned
  • filter (TEXT, Optional): SQL WHERE clause to filter search results. For example: category = ‘support’ AND status = ‘active’
  • limit (NUMBER, Optional): Maximum number of search results to return. Default is 10
  • includeFullMetadata (BOOLEAN, Optional): If enabled, returns the complete raw Snowflake API response including all metadata. If disabled (default), returns only the query results as a clean array of objects
Output: Returns the operation result