Jhames Mejia's Avatar

Jhames Mejia

@codingjhames.bsky.social

4 Followers  |  5 Following  |  6 Posts  |  Joined: 01.11.2024
Posts Following

Posts by Jhames Mejia (@codingjhames.bsky.social)

Totally agree! Schema drift was a great lesson today. dlt handles schema versioning out of the box, storing it as YAML in the destination. It definitely gives me peace of mind knowing the evolution is tracked even if the API changes. Thanks for the insight!

25.02.2026 17:48 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

#DEZoomcamp W6: dlt & DuckDB! 🏁

Schema drift: API changed tip_amount to tip_amt. ⚠️
DuckDB's error logs pointed out the fix instantly.

Running #dlt on an AWS t3.micro (1GB RAM).
0.2666 Credit prop | 6063.41 Tips.

Repo: github.com/CodingJhames/de-zoomcamp-james

#DataEngineering #AWS #BuildInPublic

24.02.2026 19:55 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Thanks, Jeremy! Performance took a hit due to disk I/O, but the goal was to prove that logic beats a tight budget. I used the zone data for a join, and you're rightβ€”it’s the perfect case for broadcast joins to avoid exploding that 1GB RAM limit!.

23.02.2026 14:45 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
GitHub - CodingJhames/de-zoomcamp-james Contribute to CodingJhames/de-zoomcamp-james development by creating an account on GitHub.

Data Engineering Week 5: Done! 🏁

Pivoted to #AWS from GCP. ☁️
Ran #PySpark on a t3.micro (1GB RAM) using a 4GB Swapfile. Processed NYC Taxi data smoothly without crashes. 🧠

Adaptability > Tools. 🦾

Code: github.com/CodingJhames...

#DataEngineering #Spark #AWS #OpenSource

18.02.2026 13:35 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 3    πŸ“Œ 0
Post image

Week 4 Analytics Engineering: Complete! πŸ‘¨β€πŸ’»

Mastered dbt with NYC Taxi data in AWS Athena. Overcoming those Parquet type mismatches was the final boss! πŸš€

Project link:
github.com/CodingJhames...

#DataEngineering #dbt #BuildInPublic

14.02.2026 20:58 β€” πŸ‘ 2    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0
Preview
GitHub - CodingJhames/de-zoomcamp-james Contribute to CodingJhames/de-zoomcamp-james development by creating an account on GitHub.

Week 3 #DataZoomcamp done! πŸš€

Migrated the DW logic to AWS Athena & S3 ☁️

πŸ”Ή 20M+ records with #Kestra πŸ”Ή Optimized queries: 310MB β†’ 26MB scan using Partitioning & Clustering πŸ”Ή Mastered cloud-agnostic DW concepts

Check my repo: πŸ”— github.com/CodingJhames...

#DataEngineering #AWS #Athena

06.02.2026 18:34 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0