Snowflake

The Snowflake tool provides access to agents to query data in Snowflake.

When to use

If all you are quering is simple tabular data then you can levearge the Dataset tool. If you need access to more query constructs than what is supported by the Dataset tool or need more complex return types then use this native Snowflake tool.

Pre-requisites

A connection to Snowflake should already have been made in the Data Studio. You can set up a connection in the Configurations section for your database.

Set up

To create a Snowflake tool, click on Create Tool from the Tools Repository and choose Snowflake

You will get the Snowflake Tool Editor -

As with all tools provide a meaningful name and description that will help the agent understand the purpose of this tool so that the agent can use it correctly.

Configuration

Storage: Select the Snowflake configuration you configured in the Data Studio

Database: Select the database you want to use

Query: The Snowflake SQL query you want to execute. Parameters can be specified using ${parameter name} e.g. SELECT OBJECT_CONSTRAINT(*) FROM MY_SCHEMA.PRODUCTS WHERE PRODUCT_ID = ${productId}

Input Parameters: Any parameters in the Query section will be listed here. You should specify the type and the description

Output: Describe the output type of the query

Testing

As with all tools, you can test this tool by providing values for the input parameters.