Sign up or log in to watch the video
Enjoying SQL data pipelines with dbt
Matthias Niehoff - 5 months ago
SQL is an indispensable tool in data analysis - it is comparatively easy to learn and uncomplicated to run on a database. Accordingly, it is very popular with many data analysts. In reality, one often finds the pattern: Python glue code in notebooks that executes SQL statements.dbt (data build tool) is a command line tool for building data pipelines in a structured way with SQL. It also enables the validation of data. And as a result, there are not only tables in a database, but also documentation and dependency graphs. Regular analyses and evaluations can also be conveniently automated. The whole thing not only helps with the preparation of data. The subsequent regular analyses and evaluations can also be conveniently automated. Including traceability, which analysis uses which data. And if there are errors in the content of the basic data, the evaluations based on it are not even updated. With dbt, even a developer will have fun with SQL & data transformations!
Jobs with related skills
Lead Developer (m/w/d)
ATLAS Dienstleistungen für Vermögensberatung GmbH
·
25 days ago
Frankfurt, Germany
Hybrid
DevOps Engineer –Infrastruktur & Automatisierung (w/d/m)
Haufe Group
·
today
Hanover, Germany
Hybrid
Softwarearchitekt *in Schwerpunkt Integration / APIs
Baloise DE
·
4 days ago
Bad Homburg, Germany
Hybrid
Softwareentwickler/in (w/m/x) Full Stack
FIZ Karlsruhe – Leibniz-Institut für Informationsinfrastruktur
·
5 days ago
Karlsruhe, Germany
+1
Hybrid
Related videos