Skip to content

Latest commit

 

History

History
27 lines (19 loc) · 981 Bytes

README.md

File metadata and controls

27 lines (19 loc) · 981 Bytes
Raw

Snowflake UDFs

This directory contains user-defined functions which mimic the behavior of proprietary functions in Snowflake. Each UDF within this directory will be automatically synchronized to the bqutil project within the sf dataset for reference in queries.

For example, if you'd like to reference the factorial function within your query, you can reference it like the following:

SELECT bqutil.sf.factorial(0)

UDFs

Documentation

factorial(integer_expr INT64)

Computes the factorial of its input. The input argument must be an integer expression in the range of 0 to 27. Due to data type differences, the maximum input value in BigQuery is smaller than in Snowflake. Snowflake docs

SELECT bqutil.sf.factorial(10)

3628800