BigQuery Structs and Javascript UDFs

Published: 17 April 2022
on channel: Dickson Tsai

1,998

In this video, we go over the struct data type in BigQuery SQL, then explore how to use them in Javascript User-Defined Functions.

Note that every flavor of SQL has a different set of features, so some BigQuery features described here are not present in others.

0:05 What is a struct in BigQuery?
1:21 How do I create a struct?
3:10 Additional rules for structs
4:41 SELECT AS STRUCT
5:30 UNNEST and structs
6:12 Javascript in SQL (CREATE TEMP FUNCTION LANGUAGE JS)
8:23 Javascript UDF examples
10:06 Javascript UDF real-world example: Sequence analysis on the Austin Bikeshare dataset

Jamboard: https://jamboard.google.com/d/1cdGkKi...
BigQuery Docs:
https://cloud.google.com/bigquery/doc...

On this page of the site you can watch the video online BigQuery Structs and Javascript UDFs with a duration of hours minute second in good quality, which was uploaded by the user Dickson Tsai 17 April 2022, share the link with friends and acquaintances, this video has already been watched 1,998 times on youtube and it was liked by 29 viewers. Enjoy your viewing!

17,888

128