User Defined Function

Mprove supports BigQuery UDFs.

.udf

Each UDF should be stored as separate function_name.udf YAML file.

For example multiply_inputs.udf:

udf: multiply_inputs       
sql: |
  CREATE TEMPORARY FUNCTION multiply_inputs(x FLOAT64, y FLOAT64)
  RETURNS FLOAT64
  LANGUAGE js AS """
    return x*y;
  """;

UDF Parameters

Name	Type	Default	Description
udf*	string	-	UDF name
sql*	string	-	(BigQuery) SQL expression