Are you your brain’s tool or is your brain your tool?
Yes, I am a Data Engineer but of course, this does not mean I do not spend time thinking about life or finding myself in it.
I am a person who likes to think about the surrounding world in technical terms. One can argue that this approach means you are not truly enjoying the beauty of life because as my dad once said for example “love is not math”. …
2 crucial techniques
I would like to start this article with one of my favourite quotes:
“If you give a man a fish, you feed him for a day. If you teach a man to fish you feed him for a lifetime.”
In our everyday busy life we tend to lose focus on what is really important when teaching others and we give away a lot of fish and this comes with consequences. At work, this approach does not really help in a long-term perspective. A person receiving help will most likely not spend time on finding “a way the…
… and never stop using it.
In this article, you will discover the magic of TDD.
If you are familiar with the typical approach of writing tests, you know that most programmers write the code before they write the tests.
Test-Driven Development describes the opposite logic — first prepare the test and then write the actual implementation code.
I am sure you may ask: “But what’s the purpose of writing a test that will fail in the first instance? Isn’t that a waste of time?”.
- Definitely not.
Starting with the test is a more result-focused approach. You have to…
The quick look at key differences between the two Google’s relational databases
Introduction to Cloud Spanner
Spanner is a product that offers global availability and horizontal scalability. Spanner is designed as a massive data solution for which it can scale up to millions of machines across hundreds of datacenters.
It is a strongly consistent and relational database fully managed for its beneficiaries. Next to all that, this distributed-systems infrastructure comes with a guarantee that your data will never be lost — Spanner replicates the data even across continents.
This Google Product offers also control over the system. Within your application…
LAST_VALUE function explained
In this article, you will learn about analytic functions and also about how to use function LAST_VALUE to fill missing data in BigQuery.
A few words about an analytic function
An analytic function takes a bunch of rows to create a group in order to compute a single value for each row.
This is where this kind of function differs from an aggregate one, which returns a single result for a group of rows.
Let’s learn by doing…
Let’s suppose we have a database that contains information about products and the corresponding prices for each day. …
SQL Function COUNT explained
What is an aggregate function?
An aggregate function is a function that operates on the multiple rows in order to group them into a single value. Grouping simplifies data analysis.
Function COUNT () is used to check the group size or to count the rows of a table.
SELECTCOUNT(*) as totalCountFROM`bigquery-public-data.google_analytics_sample.ga_sessions_20170801`