I'm looking for answers for these questions.
How come RUM User Sessions has 35 days while metric has 5 years?
Are they not pulling data from the same table?
select bounce from usersession
Solved! Go to Solution.
It can be simplified with that there are two storages. One for operation data, another - long-therm storage.
First is ElasticSerach, second is Cassandra DB.
For example you have create User session. You go to the instrumented site and do some work, for example three user actions. All of these user actions are now in ElasticSearch in JSON as separate objects.
Dynatrace do some background work and got some metrics for long therm for these objects. After 35 days when infromation will gone (3 user actions will be deleted) from ElasticSerach we still have metrics from long-therm storage - Cassandra.
This is only an example of work. The engine works much more difficult as I described.