Keboola is the core foundational piece of the data stack that North Labs prescribes to their clients.
North Labs is an end-to-end data consultancy enabling business transformation in the areas of DevSecOps, Data Engineering, and Cloud. The team serves highly regulated industries with their mission-critical digital implementations, while simultaneously safeguarding data and ensuring compliance.
We talked to Daniel Rothamel, Cloud Data Delivery Engineer at North Labs, to better understand how the joint solution of Snowflake, Keboola, and North Labs helps their customers to get more value from their data.
First, let’s look at how Daniel’s team at North Labs uses Keboola to empower their clients.
The North Labs team was asked to align data sources into the Snowflake data warehouse for a manufacturing company in North America. The company needed a single source of truth for all of their reporting.
The main challenge was that the company used ERP systems with non-standard data organization and non-trivial data extraction specifications.
One of their plant managers was spending more than 10 hours a week manually creating Excel spreadsheets which showed their customers expected production versus actual production.
Every week, the plant manager had to complete the following steps:
He was doing all of this manually.
To help him out, North Labs used Keboola to automate the process end to end.
Keboola was used to ingest data from the ERP systems into Snowflake, build transformations, and feed the cleaned data into their data visualization software. This automated the entire end-to-end pipeline to produce reports without any additional work.
Now, all the plant manager needs to do is go to a dashboard and pull those numbers automatically.
North Labs was helping an online education company build a data foundation to understand how marketing and sales are driving growth.
The challenge? Before North Labs was called in to help, the online education company built its own data ecosystem. It was a Zapier spaghetti mess.
With more than 200 zaps integrating data across dozens of sources, it was hard to understand data provenance and semantics. The client’s data team was “handcuffed to the source systems” and had to follow the structure of the data sources before every analysis.
North Labs started by untangling the existing DataOps into a more observable, scalable, and maintainable set of ETL pipelines in Keboola.
By piping the clean data into Snowflake - a central source of truth for marketing and sales information - North Labs validated the data before exposing it to analysts and made data consumption more accessible and self-serviceable.
“Without Keboola, it would have taken weeks and likely months to get their data ingested because of their source systems. With Keboola, our engineers were ingesting data within hours.”
For every data pipeline you build and every data process you engineer, you need to be monitoring and optimizing.
And when you’re North Labs, those DataOps processes accumulate with every client.
North Labs had two goals they wanted to chase:
To achieve these, they needed telemetry data to help them build those all-important health, consumption, and efficiency reports.
Luckily, Keboola exposes telemetry data out of the box, enabling the North Labs team to build the telemetry infrastructure.
“Other tools have that data, but you can't really access it. You can see it, but you can't play with it. With Keboola we get to play with it, and we get to tweak it.”
So, how do these use cases translate to North Labs’ services?
North Labs noticed that many organizations on the market have data, know that it’s valuable, and recognize that they should be getting better insights. The thing that they lack is the internal resources needed to set up the DataOps processes and turn data into insights.
This is where North Labs’ Data Concierge offering comes in.
Data Concierge offers North Labs as an extension of the client’s in-house team. North Labs takes care of the data ingestion, cleaning, modeling, and other DataOps engineering, so that “the company's team can focus on driving value for the business because that's really where their time and effort is best spent”.
Central to this offering is Keboola:
“Keboola is central to our Data Concierge offering. It has so many features that help you take advantage of your data. Everything is very customer-centric and easy to use. Keboola is a really incredible tool for centralizing and unifying your DataOps.”
Now, let’s go back to the beginning and learn how North Labs discovered Keboola and why they were selected over other alternatives on the market.
The story began with solving a problem.
“We had a customer that had a specific source system that we needed to connect to for the ETL pipeline. And we couldn't find a connector anywhere. We were trying to figure out how we were going to build a connector, and avoid additional engineering costs as well as awkward conversations with the client. In looking through the Snowflake partners, we found Keboola.”
Keboola entered North Labs’ radar by offering an out-of-the-box Generic Extractor, which helps to speed up data extraction from any API-like source.
As North Labs explored Keboola, they realized the platform fully aligns with their organizational needs:
What about the alternatives? As Daniel says:
“Well, we looked into other tools available on the market. But really, Keboola is the best solution. This is why it is a core foundational piece of the data stack that we prescribe to our clients.”
Curious to see what use cases Keboola can unlock with your data?