Remove Data Validation Remove Data Warehouse Remove Generalist Remove SQL
article thumbnail

Audit_helper in dbt: Bringing data auditing to a higher level

dbt Developer Hub

Auditing tables is a major part of analytics engineers’ daily tasks, especially when refactoring tables that were built using SQL Stored Procedures or Alteryx Workflows. Easy and intuitive code : Because audit_helper relies on dbt macros, it was designed to be an intuitive tool that runs on simple SQL queries.

article thumbnail

97 things every data engineer should know

Grouparoo

This provided a nice overview of the breadth of topics that are relevant to data engineering including data warehouses/lakes, pipelines, metadata, security, compliance, quality, and working with other teams. 69 The End of ETL as We Know It Use events from the product to notify data systems of changes. Be adaptable.