@26:17 - the sort order is importat so that join will choose a more optimized join algorithm ! In this case the merge join as the data sets are already pre- sorted
Great..Thank you! Could you please share the tutorials where we can get in depth understanding of google big query like functions and their applications. Thank you!
@26:17 - the sort order is importat so that join will choose a more optimized join algorithm ! In this case the merge join as the data sets are already pre- sorted
Great..Thank you! Could you please share the tutorials where we can get in depth understanding of google big query like functions and their applications. Thank you!
What does FLATTEN do in BigQuery?
What was said about indexing at around 23:15~
"There are no indexes in BigQuery, so you don't have to worry about it."
He said "We run no indexes in big query" . I think he meant there is no option and no need to do indexing in big query.
how to create bigquery client id and client secret
In order to do things fast, you don't have to be smart; you just need a lots of hardware! :D
only the query job structure picture matters, this film is too old.
Great !