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
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
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
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
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
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
Exercise project for anyone starting in data engineering startdataengineering.com/post/data-engi… #dataengineering #bigdata #ETL #ApacheAirflow #AWS #ApacheSpark
Preparing for SQL interviews? Do Leetcode SQL hard, sort by freq, and do the first 40 #data #dataengineering #Software #SQL
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
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
![startdataeng's tweet image. 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](https://pbs.twimg.com/media/FQyi00EXoAMO4cg.jpg)
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
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.
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. #RomanEmpireByBangChan 14.3K posts
- 2. ROMAN EMPIRE OUT NOW 12.4K posts
- 3. Jayden Daniels 25.3K posts
- 4. Good Monday 26.2K posts
- 5. jungkook 602K posts
- 6. #MondayMotivation 26K posts
- 7. #STARDOM 5,056 posts
- 8. Dan Quinn 7,122 posts
- 9. Perle Labs 5,256 posts
- 10. #River 7,244 posts
- 11. Seahawks 38.9K posts
- 12. Jake LaRavia 6,331 posts
- 13. 60 Minutes 79.3K posts
- 14. Commanders 50.7K posts
- 15. Sam Darnold 15.3K posts
- 16. Godzilla 45.8K posts
- 17. #RaiseHail 8,876 posts
- 18. Bronny 15.7K posts
- 19. Snopes 3,456 posts
- 20. Jaxson Hayes 3,428 posts
قد يعجبك
-
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 -
Neelesh Salian 💻
@neelesh_salian -
Sarah Floris
@ADutchEngineer -
Robert Yi 🐳
@imrobertyi
Something went wrong.
Something went wrong.