Class Routine.Builder (2.53.0)

publicstaticclass Routine.BuilderextendsRoutineInfo.Builder

Inheritance

java.lang.Object > RoutineInfo.Builder > Routine.Builder

Inherited Members

publicRoutinebuild()

Creates a RoutineInfo object.

RoutineInfo.Builder.build()

publicRoutine.BuildersetArguments(List<RoutineArgument>arguments)

Specifies the list of input/output arguments for the routine.

RoutineInfo.Builder.setArguments(List<RoutineArgument> argumentList)

publicRoutine.BuildersetBody(Stringbody)

Required. The body of the routine.

For functions, this is the expression in the AS clause.

If language=SQL, it is the substring inside (but excluding) the parentheses. For example, for the function created with the following statement:

CREATE FUNCTION JoinLines(x string, y string) as (concat(x, " ", y))

The definitionBody is concat(x, " ", y) ( is not replaced with linebreak).

If language=JAVASCRIPT, it is the evaluated string in the AS clause. For example, for the function created with the following statement:

CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return " "; '

The definitionBody is

return " ";

Note that both are replaced with linebreaks.

RoutineInfo.Builder.setBody(String body)

publicRoutine.BuildersetDataGovernanceType(StringdataGovernanceType)

Sets the data governance type for the Builder (e.g. DATA_MASKING).

See https://cloud.google.com/bigquery/docs/reference/rest/v2/routines

RoutineInfo.Builder.setDataGovernanceType(String dataGovernanceType)

publicRoutine.BuildersetDescription(Stringdescription)

publicRoutine.BuildersetDeterminismLevel(StringdeterminismLevel)

Sets the JavaScript UDF determinism levels (e.g. DETERMINISM_LEVEL_UNSPECIFIED, DETERMINISTIC, NOT_DETERMINISTIC) only applicable to Javascript UDFs.

RoutineInfo.Builder.setDeterminismLevel(String determinismLevel)

publicRoutine.BuildersetImportedLibraries(List<String>libraries)

Optional. If language = "JAVASCRIPT", this field stores the path of the imported JAVASCRIPT libraries as a list of gs:// URLs.

RoutineInfo.Builder.setImportedLibraries(List<String> importedLibrariesList)

publicRoutine.BuildersetLanguage(Stringlanguage)

Sets the language for the routine (e.g. SQL or JAVASCRIPT)

RoutineInfo.Builder.setLanguage(String language)

publicRoutine.BuildersetRemoteFunctionOptions(RemoteFunctionOptionsremoteFunctionOptions)

Optional. Remote function specific options.

RoutineInfo.Builder.setRemoteFunctionOptions(RemoteFunctionOptions remoteFunctionOptions)

publicRoutine.BuildersetReturnTableType(StandardSQLTableTypereturnTableType)

Optional. Set only if Routine is a "TABLE_VALUED_FUNCTION".

RoutineInfo.Builder.setReturnTableType(StandardSQLTableType returnTableType)

publicRoutine.BuildersetReturnType(StandardSQLDataTypereturnType)

Sets the return type of the routine.

Optional if language = "SQL"; required otherwise.

If absent, the return type is inferred from definitionBody at query time in each query that references this routine. If present, then the evaluated result will be cast to the specified returned type at query time.

RoutineInfo.Builder.setReturnType(StandardSQLDataType returnType)

publicRoutine.BuildersetRoutineType(StringroutineType)

Sets the routine type for the Builder (e.g. SCALAR_FUNCTION).

See https://cloud.google.com/bigquery/docs/reference/rest/v2/routines

RoutineInfo.Builder.setRoutineType(String routineType)