Systems | Development | Analytics | API | Testing

How do you link BigQuery with Google Sheets? Importing a table from Google BigQuery to Google Sheets is quite easy. In fact, you can connect BigQuery tables directly to the Google Sheets spreadsheet with a couple of clicks using Connected Sheets, the new Google BigQuery data connector (check the full instructions here). But what if you want to move data the other way around? That is, how do you send Google Sheets data to your Google BigQuery data warehouse? Now your life becomes a bit more complicated.

Keboola is proud to announce the addition of dbt to the transformation layer. Now anyone who knows SQL can build production-grade data pipelines by embracing the software engineering approach.

A data extraction tool can help you speed up one of the most error-prone engineering processes: collecting raw data from different sources. In this article, we are going to analyze the following 6 market leaders in data extraction: Before we dive in, let’s look at all the problems you can avoid by implementing a data extraction tool.

Snowflake is a cloud-based software-as-a-service (SaaS) data warehouse. It offers separate and on-the-fly scalable services for data storage, compute, and analytics.

The data transformation process reshapes data from a raw mess to a business goldmine by: Using a data transformation tool streamlines the entire process and saves you time and energy on these valuable but tedious tasks. In this article, we’ll explore the 7 best tools on the market for data transformations. Each tool will be evaluated with Pros, Cons, and a clear decision for who this tool is best for. Are you in a hurry?

When you look closer at the Modern Data Stack (MDS) you need to brace yourself. The number of tools companies use for their databases, user administration, data extraction, data integration, security, machine learning, and a myriad of other use cases has grown astronomically. Matt Turck, VC at FirstMark, composes a yearly infographic of the hot tools in the datascape: And this is just a shortlist of both the most popular and fastest-growing tools.

Gaining insights from your data can be time-consuming. Or as simple as a few clicks. Depending on if you want to do everything by yourself, or if you let us help. For example, next time one of your stakeholders asks: “Can you deliver the dashboards by the end of next week?” You can say yes with confidence, and in this blog we are going to show you why and how it is done.

Oh boy, it’s been more than a year again since my last HKBFUKC article (yep, that’s a new standard abbreviation). This is the fourth article in the series. You can always check out the first, second and third on our blog. Again, loads of stuff has happened since the last time. I made the top 16 at the 4 Seasons MTG Legacy tournament in Bologna, I visited Lego House in Billund and I got married!

Planetly uses technology to simplify carbon management for companies at scale. Their data-driven software solution helps companies reach net-zero emission targets in four steps: The entire carbon management life cycle is powered and fueled by data. We talked to Cari Davidson, VP of Engineering and Patricia Montag, the Engineering Lead Analytics, to better understand what role Keboola (and data as a whole) play in the company’s operations and what that means for the engineering team.

Over the years, Keboola and Snowflake have seen their own share of successes and incredible achievements. Now, we can proudly announce that Keboola has joined the Powered by Snowflake program. With both companies founded around the same time, Keboola and Snowflake have been working hand in hand for some time now.