Update: I've managed to figure it out - it seems to depend on the underlying DWH engine, as dbt would use native functions to grab the current timestamps (e.g. now()), which would behave differently in different environments. I guess this is why there's no mention of it in the documentation...

In my case, using Redshift as our DWH engine, this would be UTC.

This link was helpful in tracking it down.