When data is to be retained, downsampled, or eliminated from a: database, filesystem or other storage device use 'retention'.
Questions tagged [retention]
203 questions
1
vote
0 answers
Weekly cohorts of subscribers retention
My analysis subjects remind Netflix subscribers. Users subscribe on a certain date (e.g. 2021-04-25) and unsubscribe on another date (e.g. e.g. 2022-01-15) or null if user is still subscribed:
user_id subscription_start subscription_end
1231 …
Paul
- 11
- 1
1
vote
1 answer
Kusto table - How to recover soft-deleted data that is retained by the Recoverability = enabled set
I have a Kusto database with the following retention policy:
{
"SoftDeletePeriod": "30.00:00:00",
"Recoverability": "Enabled"
}
Yesterday some data was removed from a table in the database since it was over 30 days old.
According to the…
satoukum
- 1,188
- 1
- 21
- 31
1
vote
1 answer
Angular Multiple Page Data Retention Challenge
I got a specific question on an Angular Mobile Web where I will have several pages on a sequence for the user to type in the data, Let's say Page 1, Page 2, and Page 3. The user will navigate from page 1 to page 2 and page3, and eventually collects…
LittleLingzi
- 21
- 3
1
vote
0 answers
SQL Retention based on cohort and period
I have already seen all the related posts, but none have been able to help me.
I Have the following fields:
Where:
SOLD_AT is the date of each transaction
CUSTOMER_ID is a unique ID for each customer
COHORT is the date (Year-Month) of the first…
Alejandro Marín
- 73
- 7
1
vote
1 answer
How to apply retention time configuration for Dead Letter Queue in Spring Cloud Stream Kafka Binder?
I have an application using Spring Cloud Stream Kafka.
For user defined topics I can delete records from specified topics by giving the configuration I mentioned below. But this configuration doesn't work for DLQ Topics.
For example in the…
omerstack
- 535
- 9
- 23
1
vote
1 answer
Spring Cloud Stream Kafka Replication Factor and Retention Problem at Runtime
I have a spring boot project using Kafka. I configured it with Spring Cloud Stream Kafka auto configuration. I want to create my topics automatically with 3 replicas and 1 day retention. For this I added replication factor and retention.ms to my…
bugrayildirim
- 13
- 3
1
vote
1 answer
Is it possible to execute a delete query on the default retention policy in influxdb?
Influx database named "metrics" with two retention policy and assign one as default out of the two.
CREATE RETENTION POLICY basic ON "metrics" DURATION 2h REPLICATION 1 SHARD DURATION 6m DEFAULT
CREATE RETENTION POLICY downsample ON "metrics"…
Rajan
- 416
- 1
- 7
- 25
1
vote
1 answer
First Week Retention with MongoDB
One table with session start events:
Registered - unixtime - when the user was registered (first time opened the app)
DateTime - unixtime - time when the event was sent (when player installs the app and opens it for the first time: Registered =…
Alex Kotlaroff
- 13
- 2
1
vote
1 answer
Firebase - Retention Rates(Cohort)
I have a question on the way Firebase calculates retention rates.
At my company, we release a new version almost every 2-3 weeks, and a lot of people uninstall the app to get the latest version.
If an active user uninstalls and reinstalls the app to…
Joon Beh
- 11
- 2
1
vote
0 answers
week-on-week cohorts, python pandas, sql
Hey guys I'm a total newbie to creating cohorts and would really appreciate, if i receive any help (through python code or sql query)...
lets assume the bike-taxi ride(similar to uber) data-set as below:
**Note:**columns relevant for the cohort…
pavan patro
- 11
- 2
1
vote
0 answers
How to use Google Vault APIs to manage gmail retention rules?
I'm implementing automation of our G-Suite operations. What's proper service/api to get/set gmail retention rules on org units? Google Vault API reference here https://developers.google.com/vault/quickstart/python covers few topics, but nothing…
ansa
- 71
- 5
1
vote
1 answer
How to Calculate Month over Month User Retention based on already active users (not based on user signup date)?
I have a Table which tracks User activity (i-e user started a session at what time ?). This table contains the data from Dec 2018 Till now. I need to calculate monthly retention (not based on signup date) based on user Activity( i-e In December…
FridgeBot
- 13
- 3
1
vote
1 answer
create a retention table base on games played
Situation:
I have a table with three columns:
date
game
user_id
From that table I need to create a retention table that will ultimately look like this:
Output:
+------------+-------------+------+-------------+------+------+-------+
| date | …
Roger Steinberg
- 1,554
- 2
- 18
- 46
1
vote
0 answers
Delete retention policy for database with default true. What happens to the database retention policy in this case?
Delete retention policy for database with default true. What happens to the database retention policy in this case?
Step
> show retention policies on market
name duration shardGroupDuration replicaN default
---- --------…
유성현
- 11
- 1
1
vote
1 answer
Cohort analysis in R (independent of first time seen)
I'm trying to build a retained cohort table, but I'm having trouble to set it up to return distinct count ids for each period independent of first time seen (as in not related to the first period they are seen in the data).
I've been trying a…
karips
- 151
- 1
- 1
- 11