Systems | Development | Analytics | API | Testing

Blog

BigQuery and surrogate keys: a practical approach

When working with tables in data warehouse environments, it is fairly common to come across a situation in which you need to generate surrogate keys. A surrogate key is a system-generated identifier that uniquely identifies a record within a table. Why do we need to use surrogate keys? Quite simply: contrary to natural keys, they persist over time (i.e. they are not tied to any business meaning) and they allow for unlimited values.

Are you missing out leaving important data standing on the outside?

Every now and then you can't beat a bit of Meat Loaf, the singer not the food, as I've not had the pleasure to taste it. I recently found myself recalling a cult classic "Standing on the outside" not because of any failed break up but thinking about the abundance of data available externally that can be used in combination with your internal data. Unfortunately, many are still leaving this data standing on the outside.

Overview: Talend Server Applications with Docker

Since the release of Talend 7, a major update in our software, users have been given the ability to build a complete integration flow in a CI/CD pipeline which allows to build Docker images. For more on this feature, I invite you to read the blog written by Thibault Gourdel on Going serverless with Talend through CI/CD and Containers.

Top Devices and OS Versions for Testing iOS and Android Apps in 2018

Realistically speaking, how many times do you redownload an application that’s buggy? Unless it’s a hugely beneficial app, which one might begrudgingly use (off the top of my head, I can’t think of any that aren’t replaceable), users tend to just switch to an alternative app that does the same thing — sans bugs.

Big Data Is About Quality, Not Quantity

Creative Dock is a Czech startup studio where ideas for new businesses are born, and under their management these ideas become fully-fledged companies. As a client Creative Dock, therefore, represents several clients from different sectors with different needs. A client like this can be a tough nut to crack. When we won the proposal for Creative Dock it meant implementing several tools at a time, and we knew we were in for a rough ride. But we like a challenge.