Field Filter interprets BigQuery field as datetime instead of timestamp

Bug reports
1

Metabase version 1.49.22

The generated Where clause is:

where (dataset.table.status = 'sent')
and (dataset.table.business_name = 'MyBiz Limited')
and TIMESTAMP_TRUNC(dataset.table.updated_at, day, 'GMT') BETWEEN datetime "2024-08-01 00:00:00"
AND datetime "2024-08-31 00:00:00"

However dataset.table.updated_at is a timestamp, not a datetime so the query fails

This question worked a month ago before we upgraded to this version.

2

Update - I tried setting the updated_at semantic type to No semantic type and then set it back to Updated timestamp and it magically works again, but it suggests that there is a problem with Metabase "forgetting" the correct type mapping!