4 ms·
Funny to me ETL was always about getting data to a format where you can then use SQL to run whatever on. ETL means a lot of very different things to different
by lysecret 4y ago
Funny to me ETL was always about getting data to a format where you can then use SQL to run whatever on.
ETL means a lot of very different things to different people.
- papandada 4y agoYes, this was my world for a number of years too. And now "suddenly", it's not. All the "niche" stuff I started hearing about in the early 2010s seems to have hit critical mass to even be the norm in boring industries' enterprise world.
- listenallyall 4y agoI kind of think the pivoting to a new concept keeps arising because there is no magic solution. Data is hard. And yet since everybody is pretending to be experts in data mining, AI, ML, corporate execs feel left behind because they either don't have these people, or the team they do have isn't producing much, if anything, of value. Every company/enterprise has more and more data yet it isn't translating to knowledge. The existing data infrastructure isn't working, some new idea comes along and gains steam and everyone thinks it will fix their problems, it won't, and then it too will become the solution that needs to be replaced by the next new idea.
- Izkata 4y agoNote in the comments here people have used ELT instead of ETL a few times. It's not a typo, doing the "load" before the "transform" specifically refers to copying the data into the database without changing it, then doing the transformation within the database (probably with SQL).