What are user-defined functions?

Опубликовано 12 ноября 2020, 0:00

Query: Create a temporary UDF → goo.gle/2IuWgqq
Query: Create a persistent UDF → goo.gle/32Aextq
Example user-defined functions → goo.gle/3pkfyQ4
Documentation for user-defined functions → 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!

Timestamps:
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 → goo.gle/BQSpotlight
Subscribe to the GCP Channel → goo.gle/GCP

#BigQuerySpotlight

Product: BigQuery; fullname: Alicia Williams;