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_idRequiredstringRequired. Dataset ID where the routine will be created. Used in the URL path.
project_idRequiredstringRequired. 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.
routineTypeRequiredstringRequired. The type of routine: SCALAR_FUNCTION, PROCEDURE, TABLE_VALUED_FUNCTION, or AGGREGATE_FUNCTION.
securityModestringSecurity mode of the routine.
sparkOptionsobjectOptions for user-defined Spark routines.
definitionBodyRequiredstringRequired. 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.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
OAuth connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.