PinnedInData Engineer ThingsbyHenry·Apr 225 Data Ingestion Methods Every Data Engineer Should KnowHow Data Actually Gets Into Your Pipeline- Full load, incremental, CDC, streaming, and API with Python code.A response icon7A response icon7
PinnedInData Engineer ThingsbyHenry·Apr 27Data Modeling for Data Engineers: OLTP, OLAP, Inmon, and Kimball ExplainedUnderstanding OLTP, OLAP, and the two roads your data can take after the transaction is recordedA response icon2A response icon2
InLevel Up CodingbyHenry·2d agodbt Incremental Models: How to Pick the Right Strategy — [dbt Series #9]Append, merge, delete+insert and insert_overwrite, each with a business case and Snowflake codeA response icon1A response icon1
InLevel Up CodingbyHenry·Oct 2dbt Materializations: How to Choose Between View, Table, and Materialized View — [dbt Series #8]Cost, freshness, and the layer rule that settles most modelsA response icon2A response icon2
Henry·Sep 12Networking Is the One Skill AI Still Can’t Teach You in Your Data CareerStop Asking for Advice on Coffee Chats. Ask for Stories InsteadA response icon1A response icon1
InLevel Up CodingbyHenry·Sep 25 Snowflake Mistakes Burning Your Compute Budget (And How to Fix Them)A pragmatic guide for Data and Analytics Engineers to stop wasting credits and write cost-efficient modelsA response icon1A response icon1
InLevel Up CodingbyHenry·Aug 3Jinja and Macros in dbt: Stop Writing the Same SQL Twice [dbt Series #7]dbt + DuckDB series: Jinja templating, reusable macros, and the dbt-utils shortcuts are worth knowing.A response icon1A response icon1
InData Engineer ThingsbyHenry·Jul 22Terraform 101 for Data Engineers: How to version-control your AWS infrastructureA practical guide to the four core Terraform files—with a working S3 + Glue ELT, AWS example
InData Engineer ThingsbyHenry·Jul 10dbt Snapshots Explained: Track How Your Data Changes Over Time [dbt Series #6]A hands-on guide to building Type 2 slowly changing dimensions with dbt and DuckDBA response icon2A response icon2
InLevel Up CodingbyHenry·Jul 6How to Set Up AWS IAM for a Data Team the Right Way (With Adaptable Policy JSON)A practical guide to AWS IAM — four roles, four services, and the policy JSON behind each one