Tables become unavailable during run with Postgres

I’m moving the discussion from the GitHub issue: Tables become unavailable during run with Postgres · dbt-labs/dbt-core · Discussion #6227 · GitHub to this platform, as the issue has remained unanswered since 2023, and we are currently encountering the same problem with our dbt setup (dbt cloud).