A customer ran into an issue with extremely long session lengths which skew aggregations.
After a certain time, the session should be timed out. Perhaps we can create a filter on session lengths via leveraging a variable for session max duration, and have the default be 1440 minutes (1 day). For sessions longer than the limit we can consider setting it to null
The change will take place in amplitude_sessions, where the session length gets calculated.
Additions: session length variable, and a decision log explaining the default
Relevant error log or model output
No response
Expected behavior
Remove tail-end edge cases of session lengths
dbt Project configurations
n/a
Package versions
n/a
What database are you using dbt with?
bigquery
dbt Version
1.6
Additional Context
No response
Are you willing to open a PR to help address this issue?
[X] Yes.
[ ] Yes, but I will need assistance and will schedule time during our office hours for guidance
Is there an existing issue for this?
Describe the issue
A customer ran into an issue with extremely long session lengths which skew aggregations.
After a certain time, the session should be timed out. Perhaps we can create a filter on session lengths via leveraging a variable for session max duration, and have the default be 1440 minutes (1 day). For sessions longer than the limit we can consider setting it to null
The change will take place in amplitude_sessions, where the session length gets calculated.
Additions: session length variable, and a decision log explaining the default
Relevant error log or model output
No response
Expected behavior
Remove tail-end edge cases of session lengths
dbt Project configurations
n/a
Package versions
n/a
What database are you using dbt with?
bigquery
dbt Version
1.6
Additional Context
No response
Are you willing to open a PR to help address this issue?