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 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 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.

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:

address_history: [“current”, “previous”, “birth”]

What are Structs and how are they used in BigQuery:

Deepti Garg

Data Engineer

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store