Snowflake Execute Sql for Snowflake Tools | Aident Loadout

AppsSnowflake ToolsSnowflake Execute Sql

Snowflake Tools

Snowflake Execute Sql

Execute SQL statements in Snowflake and retrieve results. Supports SELECT queries for data retrieval, DDL statements (CREATE, ALTER, DROP) for schema management, and DML statements (INSERT, UPDATE, DELETE) for data modification. Returns comprehensive result metadata including co…

Write ActionRisk level 2 of 5API key connectionFree Action

Use Snowflake Execute Sql

Owner App

Snowflake ToolsApp

Required inputs

Product

Aident Loadout Aident Playbook Editor Open-CUAK

About

Apps Skills Docs Blog Pricing Downloads Privacy Policy Terms of Service

Alternatives

vs Composio vs Zapier

llms.txtGet an AI summary of Aident Loadout

rolestring

Role name to use for execution (case-sensitive). If not specified, uses the user's DEFAULT_ROLE setting.

timeoutinteger

Execution timeout in seconds. Set to 0 for maximum timeout (604800 seconds). If not specified, uses the default timeout.

bindingsobject

Values of bind variables in the SQL statement. Use this for parameterized queries to prevent SQL injection.

databasestring

Database name to use for execution (case-sensitive). If not specified, uses the user's DEFAULT_NAMESPACE setting.

statementRequiredstring

SQL statement(s) to execute. Supports SELECT queries, DDL (CREATE, ALTER, DROP), and DML (INSERT, UPDATE, DELETE). Multiple statements can be separated by semicolons; they will be executed in sequence automatically. When querying INFORMATION_SCHEMA, always filter on both `table_…

warehousestring

Warehouse name to use for query execution (case-sensitive). Required for queries that need compute resources. If not specified, uses the user's DEFAULT_WAREHOUSE setting. Suspended or undersized warehouses cause high latency or timeouts; verify the warehouse is active and approp…

parametersobject

Session parameters to set for the statement execution. These are Snowflake session-level parameters.

schema_namestring

Schema name to use for execution (case-sensitive). If not specified, uses the user's DEFAULT_NAMESPACE setting.

Observable output

dataRequired
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulRequiredboolean
Whether or not the action execution was successful or not

Setup and approval

API key connection. Risk level 2 of 5.

Pricing and limits

Free Action

Unified payment: Not currently supported

Skills that use this Action

No published Skills explicitly reference this Action yet.

Official source

Provider source