Loading into an existing table with autogenerating primary key

The problem I’m having

I am getting an error of ‘column “id” does not exist’ when I run my incremental model.

The context of why I’m trying to do this

I am trying to load data from a lake table to an exiting table in my Postgres database. I am using an incremental model. The existing table has a primary key that is autogenerated by Postgres. My select in the incremental model sql file does not address the primary key and does set the unique key using 2 other columns. Why is there an error when I run my model when I am not including the id primary key column in my incremental model?