Spliting Json Data in one column into separate columns

Get Help
1

Hello,

I have a postgresql db connected to metabase. In one of the tables, a specific column stores the data in json format. I would like to know, how to split that data in the json into separate fields inside metabase?

We are not for profit working in covid effort. So, your help will be extremely apprciated.

2

Hi @gauthraj
Metabase currently doesn't support expanding JSON or arrays. You would have to do that in Postgres:
https://stackoverflow.com/questions/45661639/extract-and-expand-postgres-json-column-data-into-separate-table