Eka Ponkratova (@thatdatabackpacker) – Medium

Eka Ponkratova (@thatdatabackpacker)

Eka Ponkratova (@thatdatabackpacker)

Creating a Data Management Strategy

This article looks at how different practice areas within the DAMA DMBOK interact and support each other in managing and leveraging data…

Apr 9

Creating a Data Management Strategy

Apr 9

Eka Ponkratova (@thatdatabackpacker)

Is anybody loading data in fact and dimension tables the pure-Python way?

The objective of the blog is to implement Slowly Changing Dimensions Type 2 (SCD2) and fact tables with a lookup to an SCD2 using Redshift…

Mar 16

Is anybody loading data in fact and dimension tables the pure-Python way?

Mar 16

Eka Ponkratova (@thatdatabackpacker)

Moving Data with Mage on AWS ECS

What’s that all about Mage?

Dec 29, 2023

Moving Data with Mage on AWS ECS

Dec 29, 2023

Eka Ponkratova (@thatdatabackpacker)

Airflow is not an ETL tool…

Introduction

Dec 17, 2023

Airflow is not an ETL tool…

Dec 17, 2023

Eka Ponkratova (@thatdatabackpacker)

CI/CD pipeline with Google Compute Engine and GitHub Actions, part II

In the previous blog post, I reviewed how CI/CD could keep the team in sync and save time by automatically merging code changes. Today I…

Sep 30, 2023

CI/CD pipeline with Google Compute Engine and GitHub Actions, part II

Sep 30, 2023

Eka Ponkratova (@thatdatabackpacker)
in
Plumbers Of Data Science

Building a CI/CD Pipeline for Apache Airflow DAGs, part I

I was sitting and looking at the formula that calculates ROI for task automation: TIME (spent on a single manual task) x FREQUENCY (of…

Sep 16, 2023

Building a CI/CD Pipeline for Apache Airflow DAGs, part I

Sep 16, 2023

Eka Ponkratova (@thatdatabackpacker)

Part II or Stale data detection with dbt and Redshift metadata

In an ideal world, your SaaS provider, e.g. Xero allows you to export your data or has some systems in place that push data to your…

Mar 27, 2023

Part II or Stale data detection with dbt and Redshift metadata

Mar 27, 2023

Eka Ponkratova (@thatdatabackpacker)

To continue with a metrics store, part II

‘Why do we have X as a revenue in the report A and Y, in application B?’ You start digging and realize that in the first case, the analyst…

Mar 19, 2023

To continue with a metrics store, part II

Mar 19, 2023

Eka Ponkratova (@thatdatabackpacker)

Stale data detection with dbt and BigQuery dataset metadata

See Part II or last modified in Redshift at…

Mar 5, 2023

Stale data detection with dbt and BigQuery dataset metadata

Mar 5, 2023

Eka Ponkratova (@thatdatabackpacker)

Integration of dbt with other systems

“I could do X with the system but cannot complete Y. What do I do?” The rise of the modern data stack trend caused many vendors to appear…

Feb 7, 2023

Integration of dbt with other systems

Feb 7, 2023

Eka Ponkratova (@thatdatabackpacker)

Eka Ponkratova (@thatdatabackpacker)

I’m a data consultant, interacting closely with you to get data to work for you www.linkedin.com/in/eponkratova

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams