Query: Create a temporary UDF → [ Ссылка ]
Query: Create a persistent UDF → [ Ссылка ]
Example user-defined functions → [ Ссылка ]
Documentation for user-defined functions → [ Ссылка ]
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 → [ Ссылка ]
Subscribe to the GCP Channel → [ Ссылка ]
#BigQuerySpotlight
Product: BigQuery; fullname: Alicia Williams;
What are user-defined functions?
Теги
GDS: Yeswhat is BigQueryhow to use BigQueryhow to use user-defined functionswhat are user-defined functionsgetting started with BigQuerygetting started with user-defined functionswhat is a UDFBigQuery custom functionsuser-defined functions in BigQuerycreating a user-defined function with SQLuser defined functionsBigQuery tutorialsBigQuery tipsUDFs in BigQueryUDFBigQueryCloud SQLdata analyzationBigQuery SpotlightAlicia Williams