More like Hacks and Tips

Image for post
Image for post
Makefile

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”]

Image for post
Image for post

What are Structs and how are they used in BigQuery:

Struct…

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