A developer creates a reusable AI agent recipe using Goose to transform messy lost and found data into organized web applications.
A technical guide on normalizing SQL cross-join data in ColdFusion by using table prefixes and restructuring query results into nested objects.
A technical guide on splitting email address strings in Azure Logic Apps using expressions to separate the domain from the full address.
Explains core data engineering concepts, comparing ETL and ELT data pipeline strategies and their use cases.
Explores the challenges of analyzing ordinal data, focusing on transformation invariance and the limitations of statistical comparisons.
Explores using Python's pattern matching and comprehensions for efficient data cleaning, transformation, and analysis.
A guide explaining dbt macros, their purpose, benefits, and how to use them to write reusable, standardized SQL code in data transformation projects.
Part 1 of a series on data warehouse transformation flows, building intuition for analytics engineers and data professionals.
Interview with Gabi Steele, co-founder of Preql, discussing data visualization, building data culture, and the future of data transformation tools.
Explains how to handle JSON arrays in Kusto Query Language (KQL) using mv-expand and mv-apply, focusing on Azure AD Conditional Access policy data.
A technical walkthrough of using dbt and DuckDB to clean and analyze session feedback data from a tech conference.
A hands-on exploration of using dbt (data build tool) with DuckDB for local data engineering, based on a tutorial project.
A visual guide explaining core LINQ functions in C#/.NET with sketches and examples, including Select, Where, Aggregate, and more.
Explains the purpose and usage of the second 'replacer' argument in JavaScript's JSON.stringify() method.
Explains the new Object.groupBy() and Map.groupBy() methods in JavaScript for easily grouping array data, comparing them to the traditional reduce() approach.
Explores data transformation challenges in Terraform using a real-world example of managing Azure Kubernetes Service RBAC permissions.
Exploring different approaches for transforming data when using React Query with REST APIs, including backend, queryFn, and frontend methods.
Explains how to use Kafka Connect's ReplaceField Single Message Transform to include, exclude, or rename fields in data streams.
Explains how to use the Flatten Single Message Transform (SMT) in Kafka Connect to convert nested JSON data into a flat structure for database insertion.
Using KSQL to flatten nested CDC data from Kafka for use with the JDBC Sink connector.
