steampipe icon indicating copy to clipboard operation
steampipe copied to clipboard

Update JSON output to be consistent across pipelings - also handle duplicate column names

Open pskrbasu opened this issue 7 months ago • 0 comments

Update Steampipe JSON output to align all cases around a single format. Cases:

  • steampipe query --output json
  • powerpipe query run --output json
  • snapshot data format
  • Pipes query API

Proposed format:

{
  "columns": [
    {
      "name": "foo",
      "data_type": "int4"
    },
    {
      "name": "foo_{random4}",
      "data_type": "int4",
      "original_name": "foo"
    }
  ],
  "rows": [
    {
      "foo": 1,
      "foo_{random4}": 2
    }
  ],
  "metadata": {
   ...
  }
}

pskrbasu avatar Jun 27 '24 13:06 pskrbasu