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
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
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
Cortex search
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 resultscolumns
(TEXT, Optional): Comma-separated list of columns to return in the search results. If not specified, all columns are returnedfilter
(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
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:
- Enable the Snowflake integration in your workspace settings
- Authenticate using API Key
- Test the connection with a simple read operation
- 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
Issue | Solution |
---|---|
Authentication failed | Verify your API Key credentials |
Rate limit exceeded | Reduce request frequency |
Data not found | Check permissions and data availability |
Connection timeout | Verify network connectivity |