通过 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。
免费操作
目前没有已发布技能明确引用此操作。