3 ms·
SQL is fine. But as an engineer, I much prefer getting a notebook over a 1000-line plate of SQL spaghetti. Some of our data scientists prefer SQL and that's f
by ProcNetDev 4y ago
SQL is fine.
But as an engineer, I much prefer getting a notebook over a 1000-line plate of SQL spaghetti.
Some of our data scientists prefer SQL and that's fine. We figure out how to speed it up and ship it.
But I've gotten a few of them onto the PySpark+notebook train and it is just a much more productive way of working, IMO. We can extract things into functions with docs & linting. We can easily look at intermediate sub-queries. Yes, you "can" do all the in SQL but the open-source tooling for Python is just really nice.
- billythemaniam 4y agoIf you want to do it all in SQL, DBT gives similar capabilities. Modern data warehouses + DBT is really why there is a lot more "just use SQL" talk in the data engineering world recently.