Como trabalhar com dados dos tipos JSON, matriz e struct no BigQuery avaliações

Mykyta A. · Revisado há over 3 years

luca L. · Revisado há over 3 years

Micky S. · Revisado há over 3 years

Graham L. · Revisado há over 3 years

Prince S. · Revisado há over 3 years

Melany Joselyne V. · Revisado há over 3 years

google_analytics_sample dataset (ga_sessions) does not have 32 RECORD type it has 6

Felipe S. · Revisado há over 3 years

SRIRAM E. · Revisado há over 3 years

Subodh K. · Revisado há over 3 years

Manish V. · Revisado há over 3 years

Raj N. · Revisado há over 3 years

Lenar Uri B. · Revisado há over 3 years

Hai D. · Revisado há over 3 years

Didn't have to UNNEST the participants or splits fields after using a cross join. Example (Task 8): #standardSQL SELECT p.name, SUM(split_times) as total_race_time FROM racing.race_results AS r , r.participants AS p , p.splits AS split_times WHERE p.name LIKE 'R%' GROUP BY p.name ORDER BY total_race_time ASC ;

Anita E. · Revisado há over 3 years

Raj K. · Revisado há over 3 years

Mario Salvador G. · Revisado há over 3 years

Praveen E. · Revisado há over 3 years

Tech Connect G. · Revisado há over 3 years

Ahmad W. · Revisado há over 3 years

Nidhi G. · Revisado há over 3 years

洸子 田. · Revisado há over 3 years

ERIKA C. · Revisado há over 3 years

Nihal C. · Revisado há over 3 years

ok

Manuel Ivan C. · Revisado há over 3 years

Consultor E. · Revisado há over 3 years