...
Note that this will use the MD5 hash of the query file to find the checkpoints that need to updated.
Saving data as JSON
This feature is only available on Postgres databases.
You can save data as a "JSON" column. This is particularly useful when attempting to export all form or case data regardless of which fields are present - for example, if you are trying to create a simple data lake for your CommCare data.
To export all form contents as JSON, create a column in a case export file with a "Source Field" of "form" and a data type column set to "json".
To export all case properties as JSON, create a column in a case export file with a "Source Field" of "properties" and a data type column set to "json".