Re:Zapier: A $5B Unbundling Opportunity
by iamacyborg on Tuesday April 12, 2022 @01:09PM
(#31005439)
Basically, reverse ETL, ie get data from the warehouse to operational platforms. The two big players are Census and Hightouch.
Both offer no-code tools to help non-technical users make use of the data.
Re:Zapier: A $5B Unbundling Opportunity
by maxerickson on Tuesday April 12, 2022 @03:53PM
(#31007491)
What does the L mean then?
E - Extract
T - Transform
L - Load
Thanks for the links, I'll have a look.
Re:Zapier: A $5B Unbundling Opportunity
by borisjabes on Tuesday April 12, 2022 @01:10PM
(#31005449)
it refers to a somewhat poorly named concept known as reverse ETL, something we started working on back in 2018 with our product Census (getcensus.com). We launched it on HN in 2020, though it's come a long way since then :-) https://news.ycombinator.com/item?id=23034642
Nice, definitely solves some problems I had in the past. I'll keep your product in mind, I like it very much.
Think of rETL as an on-demand data lake that doesn't actually store any data (for the most part).
Yeah you can pull data and create snapshots to preserve views, but given the direction privacy and regulatory environments have been going with user data, it's incredibly sexy to be able to not have to dump data in yet another data warehouse just to use a new tool.
Perhaps the proper programming term might be co-ETL or co-data-lake? (Where we use 'co' in the same sense as eg http://blog.ezyang.com/2012/10/duality-for-haskellers/ )
If it's a typo, then sorry. But ETL is the same beast. I have few ideas where to start thanks to my programming background, but I can't imagine the marketing department guys do any of it.
Non-ideal but less expensive is still better than nothing (or too expensive to stay profitable). Not all operations are huge companies that can afford IT teams working on their behalf.