[Feature] Shorten session length

[fivetran-reneeli]

Is there an existing issue for this?

• I have searched the existing issues

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?

• Yes.
• Yes, but I will need assistance and will schedule time during our office hours for guidance
• No.