I had the same issue, mostly useless info online. Took me 2 hours to figure out that the dbt-core and the adapter I'm using (dbt-clickhouse) got updated from the previously working version 1.8.9 to 1.10.2.
Made fresh venv and installed the 1.8.9 ones and the problem was solved.