BigQuery Structs and Javascript UDFs
Вставка
- Опубліковано 5 жов 2024
- 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: jamboard.googl...
BigQuery Docs:
cloud.google.c...
Good videos. Keep it up
this is great.. thanks!