[Bug] <title>deprecated python lib in dbt-common helpers

[harry-lynch-gtg]

Is this a new bug in dbt-common?

• I believe this is a new bug in dbt-common
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version.

Expected Behavior

Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC)

Steps To Reproduce

Update the method to get current timestamp

Relevant log output

Additional Context

No response

[cfernhout]

I can add some relevant log output:

/usr/local/lib/python3.12/site-packages/dbt_common/events/logger.py:159: DeprecationWarning: datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC).
20:35:10  Completed successfully
/usr/local/lib/python3.12/site-packages/dbt_common/events/helpers.py:12: DeprecationWarning: datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC).
/usr/local/lib/python3.12/site-packages/dbt_common/events/logger.py:159: DeprecationWarning: datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC).
20:35:10  
/usr/local/lib/python3.12/site-packages/dbt_common/events/helpers.py:12: DeprecationWarning: datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC).
/usr/local/lib/python3.12/site-packages/dbt_common/events/logger.py:159: DeprecationWarning: datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC).
20:35:10  Done. PASS=10 WARN=0 ERROR=0 SKIP=0 TOTAL=10
/usr/local/lib/python3.12/site-packages/dbt_common/events/helpers.py:12: DeprecationWarning: datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC).
/usr/local/lib/python3.12/site-packages/dbt_common/events/logger.py:159: DeprecationWarning: datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC).

Running on Python 3.12 with:

dbt-adapters==1.13.1
dbt-common==1.14.0
dbt-core==1.9.1
dbt-extractor==0.5.1
dbt-postgres==1.9.0
dbt-redshift==1.9.0
dbt-semantic-interfaces==0.7.4
dbt-snowflake==1.8.0b3