We are using datomic on-prem with configuration for analytics, which we’ve started using successfully.
In our app code, when we need to reference the time when an entity was modified, we query the history db and join to the transaction entity and work it out from there.
The warehouse guys now want to use a datetime of some kind to limit the result set from presto, so that they are only pulling data into the warehouse which has not been pulled before. Typically this is done by finding the highest datetime in the current warehouse, and then reference datetime higher than that value in the SQL query.
- How would this problem be solved using the analytics SQL <-> datomic interface?
- Can a join to the transaction entity be accomplished with analytics and SQL?
How can I import data via the analytics interface into a warehouse in an efficient way?