What is the best practice to map such payload into postgres table? and what will postgres target do by default if such record is sent?

Most of the target-postgres varients attempt to denest the json object

@visch is right. • https://github.com/datamill-co/target-postgres tries to denest everything • https://github.com/transferwise/pipelinewise-target-postgres/ accepts a

data_flattening_max_level

setting