More like Hacks and Tips
I didn’t know MakeFile four months back, but as I got to know, I liked it so much that everything I do with Python, is automated now. Here are few use cases, for which I always go to the Make command:
If you ever get confused about how to select or how to create Arrays or Structs in BigQuery then you are at the right place. Arrays and Structs are confusing, and I won’t argue on that. But before I come to the confusing part, let me first tell you a little bit about what exactly each of them is and how they are different.
Arrays in BigQuery, like in any other language, are a collection of elements of the same data type.
For example, this is what an Array address_history might look like:
address_history: [“current”, “previous”, “birth”]