Česká spořitelna is the biggest Czech retail bank with 4.5 million clients across 400 branches. Running a bank of this size brings its own data challenges from strict regulatory compliance via a wide range of data management needs, to almost limitless product possibilities within the data-rich environment.

The best ETL tools help you extract, transform, and load data from multiple data sources to the data destination of your choice. But not all ETL tool providers are created equal. Some are built for high-performance big data analytics, while others offer more intuitive and cost-effective workflows for the non-technical user.

What’s the difference between knowledge and wisdom? Knowledge is knowing Excel is Turing-complete. Wisdom is not using Excel as your database. The best data engineering tools make your life easier. Speed up processes, simplify complex operations, give you insights into the machinery, and maybe save some $ along the way. In this article, we’ll give you an overview of the 7 best data tools for data engineering use cases.

Data integration can be a daunting task, and data engineers usually prefer open-source ETL solutions because of their transparency (you can always inspect the code), flexibility (tinker with the tool), and price performance (no vendor licenses, no maintenance fees). But there are many “gotchas!” with open-source tools you need to consider before picking the best tool for the job.

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.