What are user-defined functions?
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!
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 → https://goo.gle/BQSpotlight
Subscribe to the GCP Channel → https://goo.gle/GCP
#BigQuerySpotlight
Product: BigQuery; fullname: Alicia Williams;
Видео What are user-defined functions? канала Google Cloud Tech
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!
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 → https://goo.gle/BQSpotlight
Subscribe to the GCP Channel → https://goo.gle/GCP
#BigQuerySpotlight
Product: BigQuery; fullname: Alicia Williams;
Видео What are user-defined functions? канала Google Cloud Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Cloud Run Principle of Least PrivilegeDeveloping on PostgreSQL for Cloud SpannerBuilding a foundation for migration (Part 2)How MLB analyzes data with Google CloudBuild a pet tracking camera appStarting your career in cloud from ITIntroduction to Datastream for BigQueryWhat are the core principles behind Google data centers?Solving for Accessible Phone Calls | Built by Student DevelopersMedical natural language processingIntroduction to GKE cluster modesUse case: getting started with Google CloudWhat is Automatic DLP?Introduction to image generationHow to get a job in cloud without a degreeHow can you embed Looker?How to deploy Cloud Run services with GitHub ActionsHow to earn Google Cloud skill badgesGetting started with Cloud Armor Adaptive ProtectionBigLake in a minuteHow are data centers powered sustainably?