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?