dbt Developer Hub

MARCH 23, 2023

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. audit_helper is a package for dbt whose main purpose is to audit data by comparing two tables (the original one versus a refactored model).

Data Warehouse 64

Data Warehouse Generalist SQL Coding 64

dbt Developer Hub

JULY 19, 2022

We work with many analytics teams to refactor their stored procedure code into dbt. While that’s more of an issue with the team’s chosen workflow than a problem with stored procedures per se, it does reflect how legacy tooling makes analytics work harder than necessary. Why use modular dbt models instead of stored procedures? ​

Data Pipeline 52

Data Pipeline SQL Data Warehouse Coding 52

dbt Developer Hub

APRIL 24, 2023

After model refactoring, model runtime was reduced from 6 hours to 9 minutes in dbt, with clearer lineage of models and better documentation and version control. One of our main objectives was to refactor the Alteryx workflows that the marketing team utilized every day. Who isn't this post for?

BI 83

BI Data Workflow SQL Data Pipeline 83

AltexSoft

OCTOBER 26, 2023

Read our guide to Natural Language Processing , to learn more about NLP use cases, tools, and approaches. Apart from the functionality mentioned here, some AI coding tools are also capable of code refactoring, code documentation, providing explanations, and searching for certain files and code snippets. Language support. Integrations.

Coding 52

Coding Programming Language Deep Learning Java 52

phData: Data Engineering

JULY 18, 2023

The Ultimate Modern Data Stack Migration Guide phData Marketing July 18, 2023 This guide was co-written by a team of data experts, including Dakota Kelley, Ahmad Aburia, Sam Hall, and Sunny Yan. Legacy tools force users to manually build out processes that can be automated by the Modern Data Stack.

Data Warehouse 52

Data Warehouse Pipeline-centric Government Data 52