Depending on how much of the data in your json payload is required, extract data into their own table/cols. And store the full payload in a file system/cloud st

Depending on how much of the data in your json payload is required, extract data into their own table/cols. And store the full payload in a file system/cloud storage.