How to get the count of records updated by the DML statement?

The problem I’m having

I am writing update SQL in dbt. But , I want to know how many records this UPDATE affected. Like SQL%ROWCOUNT was the solution in Oracle.

The context of why I’m trying to do this

What I’ve already tried

Nothing yet