Query: Create a temporary UDF → https://goo.gle/2IuWgqq
Query: Create a persistent UDF → https://goo.gle/32Aextq
Example user-defined functions → https://goo.gle/3pkfyQ4
Documentation for user-defined functions → http://goo.gle/39TKFLf
Looking for a way to consistently and efficiently apply business logic and/or transformations in your SQL queries? BigQuery offers you the option to create user-defined functions (UDFs) which allow you to easily use and implement custom functions when analyzing datasets in BigQuery. Watch to learn what a UDF is, how to use it, and how it can make the analysis of complex datasets easier!
0:00 – Intro
0:31 – What is a user-defined function?
2:09 – Demo in the BigQuery console
3:55 – Using and sharing UDFs
4:23 – Next steps
Watch more episodes of BigQuery Spotlight → https://goo.gle/BQSpotlight
Subscribe to the GCP Channel → https://goo.gle/GCP
Product: BigQuery; fullname: Alicia Williams;
Publisher: Google Cloud
You can watch this video also at the source.