BigQuery Custom UDFs

udfs.sql

create or replace function dataset.array_int_least(x array<int64>) as
((select min(y) from unnest(x) as y));

create or replace function dataset.array_int_greatest(x array<int64>) as
((select max(y) from unnest(x) as y));

create or replace function dataset.array_timestamp_least(x array<timestamp>) as
((select min(y) from unnest(x) as y));

create or replace function dataset.array_timestamp_greatest(x array<timestamp>) as
((select max(y) from unnest(x) as y));

create or replace function dataset.array_date_least(x array<date>) as
((select min(y) from unnest(x) as y));

create or replace function dataset.array_date_greatest(x array<date>) as
((select max(y) from unnest(x) as y));