Systems | Development | Analytics | API | Testing

Latest posts

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.

Evaluation Guide: How to Choose a Modern Analytics Platform

Businesses everywhere understand a basic truth in today's economy: No enterprise can lead - or even survive - without analytics. But not all analytics platforms are created equal. Choosing the right one is essential to making discoveries that have the power to drive real change. But too often the evaluation is based on narrowly-focused criteria around just features and functions, limiting the impact analytics can bring to your organization.

Essential Guide to API Monitoring

We've all heard the stories about the overnight sensation that took decades to achieve. The "API Revolution" has that same feel to me. Some version of APIs has been at the heart of application development for many years, but as the web application world grew more and more connected and developers learned to leverage code built outside their own application, the API industry began to boom and flourish.

Best Practices for Building a Cloud Data Lake You Can Trust

Using Talend and Amazon Web Services (AWS), financial institutions are building cloud data lakes to consolidate customer data across hundreds of sources. By validating the quality of that data and correlating data sets with automated processes, you can deliver trusted reporting that meets regulatory requirements and uncover insights for new business.