fix(source): cleanup unused key schema logic & requirements for format upsert encode avro

fix(source): cleanup unused key schema logic & requirements for format upsert encode avro #6066