Aident Loadout を通じて Google BigQuery Tools の Googlebigquery Create Routine を使用します。実行前に入力、出力、設定、料金、リスクを確認できます。
Tool to create a new user-defined routine (function or procedure) in a BigQuery dataset. Use when you need to define SQL, JavaScript, Python, Java, or Scala functions/procedures for reusable logic, data transformations, or custom masking. Supports scalar functions, table-valued…
languagestringProgramming language of the routine.
argumentsarrayOptional. Input/output arguments for the routine.
dataset_id必須stringRequired. Dataset ID where the routine will be created. Used in the URL path.
project_id必須stringRequired. Project ID where the routine will be created. Used in the URL path.
returnTypeobjectData type of a BigQuery field or function argument. Supports simple types like INT64, and complex types like ARRAY and STRUCT.
strictModebooleanOptional. If TRUE (default), the procedure body is checked for errors like non-existent tables. Set to FALSE for recursive procedures to avoid validation errors.
descriptionstringOptional. A description of the routine.
routineType必須stringRequired. The type of routine: SCALAR_FUNCTION, PROCEDURE, TABLE_VALUED_FUNCTION, or AGGREGATE_FUNCTION.
securityModestringSecurity mode of the routine.
sparkOptionsobjectOptions for user-defined Spark routines.
definitionBody必須stringRequired. The body of the routine. For SQL functions, this is the expression in the AS clause (excluding parentheses). For JavaScript, it's the evaluated string in the AS clause.
returnTableTypeobjectA table type for table-valued functions.
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
OAuth 接続。リスクレベル 2/5。
無料 Action
この Action を明示的に参照する公開 Skills はまだありません。