changed column type to clob to handle large json strings