​
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: Productivity & Collaboration
Availability: All workspace plans

​
Available Actions

​
Execute SQL

snowflake.executeSQL
Execute SQL query and return resulting data Requires Confirmation: Yes Parameters:
  • sqlQuery (MULTI_LINE_TEXT, Required): The SQL query to execute against Snowflake
Output: Returns the query results with data

​
Search schema

snowflake.searchschema
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
Output: Returns matching schemas or tables
snowflake.cortexsearch
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
Output: Returns semantic search results

​
Common Use Cases

Data Management

Manage and organize your Snowflake data

Automation

Automate workflows with Snowflake

Reporting

Generate insights and reports

Integration

Connect Snowflake with other tools

​
Best Practices

Getting Started:
  1. Enable the Snowflake integration in your workspace settings
  2. Authenticate using API Key
  3. Test the connection with a simple read operation
  4. Explore available actions for your use case
Important Considerations:
  • Ensure proper authentication credentials
  • Respect rate limits and API quotas
  • Review data privacy settings
  • Test operations in a safe environment first

​
Troubleshooting

IssueSolution
Authentication failedVerify your API Key credentials
Rate limit exceededReduce request frequency
Data not foundCheck permissions and data availability
Connection timeoutVerify network connectivity

​
Support

For additional help with the Snowflake integration, contact support@langdock.com