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。
無料 Action
この Action を明示的に参照する公開 Skills はまだありません。