BigQuery Nested and Repeated Fields - Live Example
Рет қаралды 6,702
3 жыл бұрынThis video demonstrates live example of creating and manipulating BigQuery table having Nested (RECORD) and REPEATED fields.
It covers answers for:
- How to create table having Nested (RECORD) and REPEATED fields?
- How to insert data in table having Nested (RECORD) and REPEATED fields?
- How to UNNEST the Nested (RECORD) and REPEATED fields?
Like, Comment and Share this video!
#bigquery #nestedfields #repeatedfields
@nileshdeshmukh6931 3 жыл бұрын
Thanks sir 👍
@salmansayyad4522 Жыл бұрын
Thanks🎉🎉
@sridhar43299 2 жыл бұрын
O have one doubt that is how to run the procedure s in airflow if data in postgres data base
@praveenkhanduri2819 Жыл бұрын
For example we want to update for John , for the book The Insider , pages from 200 to 250 . What will be the query ?
@Han-ve8uh 2 жыл бұрын
1. What's the difference between repeated and nested? Is it something must be nested before it can be repeated? 2. What is the FROM table, UNNEST syntax? Sometimes i see FROM table CROSS JOIN UNNEST, or FROM table LEFT JOIN UNNEST too. 3. What is FROM X,Y syntax?
@akashm8203 2 жыл бұрын
good explanation about repeated fields. how can we query --> Give me users who either have "The insider" or "The Alchemist". The result should return Krishna and John
@sanagpal 4 ай бұрын
Where can I connect you?
ISSEI / いっせい
Рет қаралды 80 МЛН
💀Skeleton Ninja🥷【にんげんっていいなチャンネル】
Рет қаралды 8 МЛН
Optizent Academy - Marketing Analytics
Рет қаралды 11 М.
Anjan GCP Data Engineering
Рет қаралды 10 М.
TESLA CAR WORLD
Рет қаралды 86 М.
Data Tech
Рет қаралды 11 М.
Google Cloud Tech
Рет қаралды 42 М.