SSTabledump
============

.. warning:: SSTabledump is deprecated since ScyllaDB 5.4, and will be removed in the next release.
             Please consider switching to :doc:`ScyllaDB SSTable </operating-scylla/admin-tools/scylla-sstable>`.

This tool allows you to converts SSTable into a JSON format file.
If you need more flexibility or want to dump more than just the data-component, see :doc:`scylla-sstable </operating-scylla/admin-tools/scylla-sstable>`.


Use the full path to the data file when executing the command.

For example:

.. code-block:: shell

   sstabledump /var/lib/scylla/data/keyspace1/standard1-7119946056b211e98e85000000000001/mc-12-big-Data.db

Example output:

.. code-block:: shell

  [
  {
    "partition" : {
      "key" : [ "3137343334334f4f4d30" ],
      "position" : 0
    },
    "rows" : [
      {
        "type" : "static_block",
        "position" : 281,
        "cells" : [
          { "name" : "\"C0\"", "value" : "0xb7789e7cdf2af541061f207714a3b8e14c72f74e663bd5c2577ac329bcb3161cf10c", "tstamp" : "2019-04-04T08:22:24.336001Z" },
          { "name" : "\"C1\"", "value" : "0xe8ed77f078a23e37f8a7246ccd8cd4099585c7031e242529e5070246860d7a1b1e85", "tstamp" : "2019-04-04T08:22:24.336001Z" },
          { "name" : "\"C2\"", "value" : "0x3b836d4333d2d5a02a63ced47596bfb5f80ecb8e80686061c3daaba87380994b7b61", "tstamp" : "2019-04-04T08:22:24.336001Z" },
          { "name" : "\"C3\"", "value" : "0x9220219581df87ff131306b8bf793c14ae8ebf8c8af1b638827ebfcab85660a378b8", "tstamp" : "2019-04-04T08:22:24.336001Z" },
          { "name" : "\"C4\"", "value" : "0x5b4c972cdeb330035b82dc0b1daa9051fff7956d45e3c6c2b21dfb1fd2bb43fb1146", "tstamp" : "2019-04-04T08:22:24.336001Z" }
        ]
      }
    ]



**NOTE:** 

When running as a user that is not ``root`` or ``scylla`` an error (java traceback) might be observed. 
To work around the error, please use the following syntax:

.. code-block:: sh

  cassandra_storagedir="/tmp" sstabledump [filename]

