4 ms·
> How do you query this data or join or filter across such disparate sources? The only two solutions today are to put ALL data into a warehouse or to write cust
by Fiahil 4y ago
> How do you query this data or join or filter across such disparate sources? The only two solutions today are to put ALL data into a warehouse or to write custom scripts. The problem with warehouses are that they are expensive and that the ETL process for every new database is expensive too.
> Tons and tons of companies are trying to solve this. You'll get lost among all the vendors trying to capitalize on the “Modern Data Stack”. They're expensive.
Yes, and Yes. However I see a path for a new kind of warehouse that isn't a "Git for Data" or a Databricks' product.
"Topics" (Kafka terminology) containing versioned datasets could help organise and discover what is available in a given repo. The Data versioning would help ensuring reproducibility of any AI pipeline consuming those, because artefacts would be kept unaltered "forever". And finally, availability would be supported by a simple set of read-only replicas.
Your best alternative today consist of stuffing a blob storage with parquet files, and giving write access to a proxy (or to everyone, if you want to live dangerously). Where are append-only semantics ? Conflict-free artefact creation with concurrent reads ?
There is massive opportunities here, it's almost exciting !
PS : > I'm particularly interested in ending up at a database or analytics company. So if you're a database or analytics company hiring managers or developers, feel free to message me!
I see you in the thread, so does a consulting company with a massive Data Science arm is of any interest to you ? :)
- eatonphil 4y ago> I see you in the thread, so does a consulting company with a massive Data Science arm is of any interest to you ? :) ha, maybe! You have my email.
- cube2222 4y agoI think Pachyderm[0] is exactly what you're describing. [0]:https://www.pachyderm.com https://www.pachyderm.com
- Fiahil 4y agoWe used pachyderm before MLOps was even a thing, sadly, back then they tried to solve everything at once while failing with the most basic needs. If your data versioning "Utilizes a Git-like structure that enables effective team collaboration through commits, branches and rollbacks", then it means you can only consume one version at a time in your pipeline. This is, unfortunately, a fatal flaw. Especially when working with time series !
- claytonjy 4y agoI also used Pachyderm pre-MLOps (2017+), specifically for time series ML (finance) and didn't see a mismatch between what we wanted and how Pachyderm worked. Were you overwriting/replacing data over time?
- nico_h 4y agoIt sounds like you’re describing datomic. Though I don’t know if it has the required density.