Tag

data-engineering

#data-engineering

More content

Read more stories on Hashnode

Articles with this tag

Dynamically extracting JSON data in BigQuery

Aug 9, 20241 min read

I was asked today about dynamically extracting key-value pairs from heterogeneous JSON-like strings in BigQuery SQL and I've remembered this...

Dynamically extracting JSON data in BigQuery

sorted(List) vs List.sorted() in Python

Aug 4, 20241 min read

When I was just starting out with Python I found the distinction between a function doing something in place and returning the result instead pretty...

sorted(List) vs List.sorted() in Python

Installing Python packages with pip

Jul 27, 20241 min read

Here are the basics you need to know about installing Python packages. Apart from the built-in modules that come by default with the Python...

Installing Python packages with pip

A practical exercise working with ARRAYS and correlated subqueries in BigQuery

Jul 6, 20242 min read

Here's an interesting SQL problem, similar to one I had to solve the other day. It involves some of our favourite BigQuery ARRAYS, but also correlated...

A practical exercise working with ARRAYS and correlated subqueries in BigQuery

My day as a Data Engineer 8 years ago

Jul 3, 20242 min read

Let's look day in the life of a Data Engineer in 2016. Wait a minute, the title is 'BI Developer' or 'BI Engineer', but you do pretty much everything...

My day as a Data Engineer 8 years ago

LAX JSON conversion functions in BigQuery

Jun 22, 20241 min read

So if you're looking to decompress after a long week and relax, check out the LAX conversion functions for handling JSON conversions in...

LAX JSON conversion functions in BigQuery