4 ms·

I would have no idea where to start with rETL and I'm a software engineer... Search turns up some medicine and other non-related stuff. If it's a typo, then so

I would have no idea where to start with rETL and I'm a software engineer... Search turns up some medicine and other non-related stuff. 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.

iamacyborg 5y ago
Basically, reverse ETL, ie get data from the warehouse to operational platforms. The two big players are Census and Hightouch. https://www.getcensus.com/ https://www.getcensus.com/ https://hightouch.io/ https://hightouch.io/ Both offer no-code tools to help non-technical users make use of the data.
- emteycz 5y ago
  Thanks for the links, I'll have a look.
- maxerickson 5y ago
  What does the L mean then?
  - me_bx 5y ago
    E - Extract T - Transform L - Load
borisjabes 5y ago
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 https://news.ycombinator.com/item?id=23034642
- emteycz 5y ago
  Nice, definitely solves some problems I had in the past. I'll keep your product in mind, I like it very much.
bduerst 5y ago
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.
- eru 5y ago
  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/ http://blog.ezyang.com/2012/10/duality-for-haskellers/ )

iamacyborg 5y ago

Basically, reverse ETL, ie get data from the warehouse to operational platforms. The two big players are Census and Hightouch. https://www.getcensus.com/ https://www.getcensus.com/ https://hightouch.io/ https://hightouch.io/ Both offer no-code tools to help non-technical users make use of the data.

emteycz 5y ago
Thanks for the links, I'll have a look.
maxerickson 5y ago
What does the L mean then?
- me_bx 5y ago
  E - Extract T - Transform L - Load

borisjabes 5y ago

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 https://news.ycombinator.com/item?id=23034642

emteycz 5y ago
Nice, definitely solves some problems I had in the past. I'll keep your product in mind, I like it very much.

bduerst 5y ago

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.

eru 5y ago
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/ http://blog.ezyang.com/2012/10/duality-for-haskellers/ )