In Python>= 3.12, you need to use

from datetime import datetime, timezone
datetime.now(timezone.utc).replace(tzinfo=None)

Accroding to https://github.com/dbt-labs/dbt-core/issues/9791 and they recommended ✅ search/replace