snowflake

Snowflake

Author: hankookncompany
Version: 0.0.1
Type: tool

Github Repository: https://github.com/hankookncompany/snowflake

Overview

Snowflake for Dify is a plugin for Dify enables AI agents and workflows interact with data warehouse.
It handles both generation and execution of SQL statements, via Snowflake's Cortex Analyst engine.

Configuration

Prerequisite

This plugin supports the following two types of authentication method for Snowflake. Since the query generation cannot be performed with password authentication, we recommend creating a dedicated programmatic user on Snowflake, and providing both password and access token.
- Password Auth :
- Programmatic Access Token(PAT) : ,
Get Snowflake tools from Dify Plugin Marketplace

The Snowflake plugin could be found at Dify Plugin Marketplace, please be patient while Dify Plugin Daemon preparing environment and installing requirements.

Fill Credentials for Snowflake

On the Dify, go to to fill the credentials.

Field	Description	Required
	Your Snowflake account identifier (e.g. or )	✅
	Your Snowflake user ID	✅
	Your Snowflake password	✅
	Programmatic access token	❌
	Snowflake warehouse to use (e.g. )	❌
	Role to assume when connecting (e.g. )	❌

Usage

Execute SQL Statements

Simply put your SQL statements into block. The response will be a json with columnar structure.

Generate SQL Statements

Snowflake Cortex Analyst is a powerful assistant to retrieve data from database with natural language. This plugin provide a tool that enables using Cortex Analyst in your Dify workflows and agents.

To use Cortex Analyst, a detailed description for data, Semantic Model and Semantic View, should be pre-defined. Please reffer to the related quickstart from Snowflake.

Once your first semantic model has been built, browse into the stage, and click dropdown menu right on your semantic model, and then click . The path should be in the format such as . Paste it into Cortex Analyst block.

The response could contain additional inforamtions more than SQL statements, such as suggestions, text, or some others. To separate SQL statements from the response, please use the block which is a build-in components of Dify.

License

Apache License 2.0

Privacy

This plugin does not collect or transmit data to third-party services.