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 Make command:
- If you don’t want to remember any long command with multiple arguments then create a Make command in MakeFile and you are good to go.
- If you want to run a set of commands one after the another but don’t want to copy paste again and again, put that code in a block in Make…
If you ever get confused 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.
What are Arrays and how are they used in BigQuery:
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:
id:”1",
name:”abc”,
age:”20",
address_history: [“current”, “previous”, “birth”]
What are Structs and how are they used in BigQuery:
Struct…
Deepti Garg
Data Engineer
