Joseph Machado
@startdataeng
I write about data engineering | SQL | Python | Distributed systems. Get my free data engineering course at http://startdataengineering.com/email-course/
내가 좋아할 만한 콘텐츠
Exercise project for anyone starting in data engineering startdataengineering.com/post/data-engi… #dataengineering #bigdata #ETL #ApacheAirflow #AWS #ApacheSpark
Starting a data project is a lot of work! It can be overwhelming to define the problem, set up systems, and then code! Use this DE project as a blueprint to build your own: startdataengineering.com/post/data-engi… #data #dataengineering #Database #DataAnalytics #dataviz #Python #datapipeline
Starting as a DE? 90% of what you will need is SQL (OLAP), python, & distributed system basics Don't overcomplicate! #data #dataengineering #SQL #Database #Python
It can be overwhelming to start learning data engineering. I'd recommend starting with the basics of python, sql, UNIX commands, building a simple data project, update Github, Linkedin. Landing a DE job is 60% part learning and 40% marketing. See reply 👇🏽 for helpful links.
An orchestration tool that I've been impressed with is @dagsterio. Easy setup, powerful features and great docs. Use 👇🏽 to play around with a pipeline on dagster startdataengineering.com/post/data-engi… #data #dataengineering #Python #Database #DataAnalytics
Exercise project for anyone starting in data engineering startdataengineering.com/post/data-engi… #dataengineering #bigdata #ETL #ApacheAirflow #AWS #ApacheSpark
Backfilling is an inevitable part of data projects. When designing your data pipelines take some time to answer the following questions 1. Does multiple backfill runs cause duplicate data? 2. Can multiple backfills be parallelized? #data #DataEngineering #datapipeline #datasets
When data to process is larger than memory, try to stream with python generators, before jumping to distributed systems! #data #dataengineering #Python #pythonlearning #Generator E.g. Stream a file(note () and not []), get diff between date cols
Learning data engineering? Build a pipeline locally. 1. Python to pull data from an API (e.g. Coincap) 2. Load data into a local Postgres container 3. Automate it with cron/task scheduler Start small, build, improve, & repeat. #data #dataengineering #pythonlearning #Python
Left anti-join is cool! Get all the data from the left table that has no matching data in the right table select t1.* from t1 left join t2 on t1.id=t2.id where https://t.co/TilIGFtVGj is null; #data #dataengineering #SQL #Database
Preparing for SQL interviews? Do Leetcode SQL hard, sort by freq, and do the first 40 #data #dataengineering #Software #SQL
If you are interested in using "Change Data Capture" pattern for streaming ETL, check out startdataengineering.com/post/change-da… #ETL #changedatacapture #dataengineering #debezium #BigData
uv by @astral_sh is truly one of the best tools you can have in your toolkit as a DE. TIL: You can quickly start a jupyter notebook with it doc: docs.astral.sh/uv/guides/inte…
Data engineers write the most complex piece of code to Upsert into tables. Here's THE command you need to know MERGE INTO/INSERT ON CONFLICT #data #dataengineering #SQL
United States 트렌드
- 1. #UFC322 38.8K posts
- 2. Ewing 5,792 posts
- 3. Bama 19.3K posts
- 4. Wellmaker 4,127 posts
- 5. Oklahoma 29.4K posts
- 6. Noah Thomas N/A
- 7. #AEWCollision 4,958 posts
- 8. Arch 17.8K posts
- 9. Wingo 1,346 posts
- 10. Jeremiah Smith 2,115 posts
- 11. Ty Simpson 3,859 posts
- 12. Bronny 5,206 posts
- 13. Boomer Sooner 2,189 posts
- 14. #GoDawgs 5,191 posts
- 15. Georgia 79.2K posts
- 16. UConn 4,787 posts
- 17. Sabatini 1,386 posts
- 18. Shapen N/A
- 19. Iowa 20.1K posts
- 20. James Peoples N/A
내가 좋아할 만한 콘텐츠
-
DuckDB
@duckdb -
Mehdi Ouazza
@mehd_io -
dbt Labs
@dbt_labs -
Data Engineering Weekly
@data_weekly -
Darshil | Data Engineer👨🏻🔧
@parmardarshil07 -
Zach Wilson
@EcZachly -
dbt
@getdbt -
Anna Geller
@anna__geller -
Maxime Beauchemin
@mistercrunch -
SeattleDataGuy
@SeattleDataGuy -
Tristan Handy
@jthandy -
Mitchell van Rijkom
@MitchellvRijkom -
Sarah Floris
@ADutchEngineer -
Robert Yi 🐳
@imrobertyi -
Simon Späti 🏔️
@sspaeti
Something went wrong.
Something went wrong.