User Defined Functions
BigQuery now supports User Defined Functions (UDFs) in SQL and JavaScript that extend
BigQuery for more specialized computations and that can be reused in notebooks and queries.
To facilitate the analysis of cancer data, ISB-CGC offers a set
of UDFs that implement commonly used statistical tests and methods in cancer research and bioinformatics.
The UDFs are located in the isb-cgc-bq.functions data set, and the source code of the functions
and examples of how to use them can be found in our Community Notebook GitHub Repository.
The following table lists all the functions available in ISB-CGC.
UDF (click for details) |
Description |
Notebooks |
|---|---|---|
K-means method for clustering data |
||
p value of the Fisher exact test |
||
Mann–Whitney U test |
||
Kruskal Walis test |
||
Significance level of the two sided T test |
||
One minus the CDF of the Chi Square distribution |
||
CDF of the Normal distribution |