search
Support

Snowflake

Snowflake allows you 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

hashtag
Available Actions

hashtag
Execute SQL

snowflake.executeSQL

Execute an 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

hashtag
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

hashtag
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 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

hashtag
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

hashtag
Best Practices

1

hashtag
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

2

hashtag
Important Considerations

  • Ensure proper authentication credentials

  • Respect rate limits and API quotas

  • Review data privacy settings

  • Test operations in a safe environment first

hashtag
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

hashtag
Support

For additional help with the Snowflake integration, contact [email protected]envelope

References

  • Docs home: https://docs.langdock.com/product/introduction

  • API: https://docs.langdock.com/api-endpoints/api-introduction

  • Learn: https://docs.langdock.com/resources/prompt-elements

(Links preserved as in the original content.)

PreviousMiroNextBig Query