通过 Aident Loadout 使用 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…
rolestringRole name to use for execution (case-sensitive). If not specified, uses the user's DEFAULT_ROLE setting.
timeoutintegerExecution timeout in seconds. Set to 0 for maximum timeout (604800 seconds). If not specified, uses the default timeout.
bindingsobjectValues of bind variables in the SQL statement. Use this for parameterized queries to prevent SQL injection.
databasestringDatabase name to use for execution (case-sensitive). If not specified, uses the user's DEFAULT_NAMESPACE setting.
statement必填stringSQL 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_…
warehousestringWarehouse 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…
parametersobjectSession parameters to set for the statement execution. These are Snowflake session-level parameters.
schema_namestringSchema name to use for execution (case-sensitive). If not specified, uses the user's DEFAULT_NAMESPACE setting.
data必填Data from the action execution
errorstringError if any occurred during the execution of the action
successful必填booleanWhether or not the action execution was successful or not
API 密钥连接。风险等级 2/5。
免费操作
目前没有已发布技能明确引用此操作。