AWS

1 Articles
Study Guide for AWS Data Analytics Specialty Certification

Study Guide for AWS Data Analytics Specialty Certification

This study guide covers AWS Certification for Data Analytics Specialty. This ...

Airbyte

1 Articles
End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

This Blog post is a WIP, but you can follow along on the Github repo here ...

Apache Airflow

2 Articles
Study Guide for DAG Authoring for Apache Airflow Certification

Study Guide for DAG Authoring for Apache Airflow Certification

This study guide covers the Astronomer Certification DAG Authoring for Apache...

Study Guide for Apache Airflow Fundamentals Certification

Study Guide for Apache Airflow Fundamentals Certification

This study guide covers Astronomer Certification for Apache Airflow Fundament...

Cloud Computing

1 Articles
Study Guide for AWS Data Analytics Specialty Certification

Study Guide for AWS Data Analytics Specialty Certification

This study guide covers AWS Certification for Data Analytics Specialty. This ...

Dagster

1 Articles
End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

This Blog post is a WIP, but you can follow along on the Github repo here ...

Data Pipelines

2 Articles
Study Guide for DAG Authoring for Apache Airflow Certification

Study Guide for DAG Authoring for Apache Airflow Certification

This study guide covers the Astronomer Certification DAG Authoring for Apache...

Study Guide for Apache Airflow Fundamentals Certification

Study Guide for Apache Airflow Fundamentals Certification

This study guide covers Astronomer Certification for Apache Airflow Fundament...

Database

2 Articles
Creating SQL Queries using Python

Creating SQL Queries using Python

In the world of data engineering, tasks that seem simple on the surface can o...

Running out of Space on your Machine? Try Clearing MySQL `binlog` Files!

Running out of Space on your Machine? Try Clearing MySQL `binlog` Files!

One day, I tried to import a more current local copy of the production databa...

Excel

1 Articles
How to Import Multiple Excel files into Pandas

How to Import Multiple Excel files into Pandas

Disclaimer: All proprietary company data has been completely anonymized and r...

GPT-4

1 Articles
Generating Custom Anki Decks with GPT-4 and LangChain

Generating Custom Anki Decks with GPT-4 and LangChain

I am no stranger to the ever-evolving world of technology as a user of the Da...

Git

1 Articles
Study Guide for GitLab Certified Associate Certification

Study Guide for GitLab Certified Associate Certification

This study guide covers the GitLab Certified Associate Certification. It is a...

Gitlab

1 Articles
Study Guide for GitLab Certified Associate Certification

Study Guide for GitLab Certified Associate Certification

This study guide covers the GitLab Certified Associate Certification. It is a...

Jinja

2 Articles
Leveraging dbt Project Variables and Jinja for a DRY Workflow

Leveraging dbt Project Variables and Jinja for a DRY Workflow

Oh, the joy of hard-coded values! Said no one ever. If you’re anything like m...

Creating Custom Macros in dbt for Efficient YAML Generation

Creating Custom Macros in dbt for Efficient YAML Generation

As a data engineer, I spend a lot of time working with YAML files. These file...

LaTeX

2 Articles
Automating the Workflow for Job Applications using Bash

Automating the Workflow for Job Applications using Bash

Navigating the job market as a Data Engineer often feels like maneuvering thr...

Creating a LaTeX Resume that Stands Out from

Creating a LaTeX Resume that Stands Out from "Jake's Resume"

If you’ve ever felt like your resume is a bland, uninspired reflection of you...

LangChain

1 Articles
Generating Custom Anki Decks with GPT-4 and LangChain

Generating Custom Anki Decks with GPT-4 and LangChain

I am no stranger to the ever-evolving world of technology as a user of the Da...

Metabase

1 Articles
End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

This Blog post is a WIP, but you can follow along on the Github repo here ...

Overleaf

1 Articles
Creating a LaTeX Resume that Stands Out from

Creating a LaTeX Resume that Stands Out from "Jake's Resume"

If you’ve ever felt like your resume is a bland, uninspired reflection of you...

Pandas

1 Articles
How to Import Multiple Excel files into Pandas

How to Import Multiple Excel files into Pandas

Disclaimer: All proprietary company data has been completely anonymized and r...

Python

4 Articles
End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

This Blog post is a WIP, but you can follow along on the Github repo here ...

Generating Custom Anki Decks with GPT-4 and LangChain

Generating Custom Anki Decks with GPT-4 and LangChain

I am no stranger to the ever-evolving world of technology as a user of the Da...

Creating SQL Queries using Python

Creating SQL Queries using Python

In the world of data engineering, tasks that seem simple on the surface can o...

How to Import Multiple Excel files into Pandas

How to Import Multiple Excel files into Pandas

Disclaimer: All proprietary company data has been completely anonymized and r...

SQL

5 Articles
Leveraging dbt Project Variables and Jinja for a DRY Workflow

Leveraging dbt Project Variables and Jinja for a DRY Workflow

Oh, the joy of hard-coded values! Said no one ever. If you’re anything like m...

Creating Custom Macros in dbt for Efficient YAML Generation

Creating Custom Macros in dbt for Efficient YAML Generation

As a data engineer, I spend a lot of time working with YAML files. These file...

Creating SQL Queries using Python

Creating SQL Queries using Python

In the world of data engineering, tasks that seem simple on the surface can o...

Using SQLAlchemy and difflib to String Match Data

Using SQLAlchemy and difflib to String Match Data

Disclaimer: All proprietary company data has been completely anonymized and r...

Running out of Space on your Machine? Try Clearing MySQL `binlog` Files!

Running out of Space on your Machine? Try Clearing MySQL `binlog` Files!

One day, I tried to import a more current local copy of the production databa...

Snowflake

1 Articles
End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

This Blog post is a WIP, but you can follow along on the Github repo here ...

Study Guide

4 Articles
Study Guide for AWS Data Analytics Specialty Certification

Study Guide for AWS Data Analytics Specialty Certification

This study guide covers AWS Certification for Data Analytics Specialty. This ...

Study Guide for GitLab Certified Associate Certification

Study Guide for GitLab Certified Associate Certification

This study guide covers the GitLab Certified Associate Certification. It is a...

Study Guide for DAG Authoring for Apache Airflow Certification

Study Guide for DAG Authoring for Apache Airflow Certification

This study guide covers the Astronomer Certification DAG Authoring for Apache...

Study Guide for Apache Airflow Fundamentals Certification

Study Guide for Apache Airflow Fundamentals Certification

This study guide covers Astronomer Certification for Apache Airflow Fundament...

bash

1 Articles
Automating the Workflow for Job Applications using Bash

Automating the Workflow for Job Applications using Bash

Navigating the job market as a Data Engineer often feels like maneuvering thr...

dbt

3 Articles
End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

End-to-End ELT with Airbyte, dbt, Dagster, Snowflake and Metabase

This Blog post is a WIP, but you can follow along on the Github repo here ...

Leveraging dbt Project Variables and Jinja for a DRY Workflow

Leveraging dbt Project Variables and Jinja for a DRY Workflow

Oh, the joy of hard-coded values! Said no one ever. If you’re anything like m...

Creating Custom Macros in dbt for Efficient YAML Generation

Creating Custom Macros in dbt for Efficient YAML Generation

As a data engineer, I spend a lot of time working with YAML files. These file...

git

1 Articles
How to Use Remote Functions to Speed Up your Data Cleaning

How to Use Remote Functions to Speed Up your Data Cleaning

Disclaimer: All proprietary company data has been completely anonymized and r...

github

1 Articles
How to Use Remote Functions to Speed Up your Data Cleaning

How to Use Remote Functions to Speed Up your Data Cleaning

Disclaimer: All proprietary company data has been completely anonymized and r...

makefile

1 Articles
Automating the Workflow for Job Applications using Bash

Automating the Workflow for Job Applications using Bash

Navigating the job market as a Data Engineer often feels like maneuvering thr...

pandas

2 Articles
Top Python Libraries for Data Science and Data Engineering

Top Python Libraries for Data Science and Data Engineering

As a language, Python has revolutionized the world of data science and data e...

Using SQLAlchemy and difflib to String Match Data

Using SQLAlchemy and difflib to String Match Data

Disclaimer: All proprietary company data has been completely anonymized and r...

python

4 Articles
Automating the Workflow for Job Applications using Bash

Automating the Workflow for Job Applications using Bash

Navigating the job market as a Data Engineer often feels like maneuvering thr...

Top Python Libraries for Data Science and Data Engineering

Top Python Libraries for Data Science and Data Engineering

As a language, Python has revolutionized the world of data science and data e...

Using SQLAlchemy and difflib to String Match Data

Using SQLAlchemy and difflib to String Match Data

Disclaimer: All proprietary company data has been completely anonymized and r...

How to Use Remote Functions to Speed Up your Data Cleaning

How to Use Remote Functions to Speed Up your Data Cleaning

Disclaimer: All proprietary company data has been completely anonymized and r...