Do we have Analytical Window function in SAM by any chance? I tried to use Analytical Window functions in structured streaming but no luck. SO wondering if i solve this using SAM? I looked into it we can do stream-stream join which is what iam looking for. However not sure if we have window RANK/LAG functionality in SAM?
Thank you