This just happened to us and we’re on the latest version of metabase 0.35.3. Postgres db would not sync, BigQuery does. Error log shows the usual “fingerprint” step error, doesn’t seem to affect anything, plus a failure on sync step. I added a new version of the postgres db and it sync’d fine. Still couldn’t get the old one to until i found this thread. I looked for all pk’s and found one that was a date. I changed it from a PK constraint to a regular index and voila, the sync started working again.
Postgres query for checking pk’s for ref:
kcu.table_name,
tco.constraint_name,
kcu.ordinal_position as position,
kcu.column_name as key_column
from information_schema.table_constraints tco
join information_schema.key_column_usage kcu
on kcu.constraint_name = tco.constraint_name
and kcu.constraint_schema = tco.constraint_schema
and kcu.constraint_name = tco.constraint_name
where tco.constraint_type = 'PRIMARY KEY'
order by kcu.table_schema,
kcu.table_name,
position;```