How I Can spliting JSON in columns

Get Help
1

Hi,
I'm working with database where one column are JSON and I need spliting it in columns. How I can do it? Now I'm using metabase version 0.34.2

2

Hi @leonardo96
You should really consider upgrading a some point: https://github.com/metabase/metabase/releases/latest
Metabase currently does not handle JSON, so you'll need to create a View on your database or use SQL, where you have split into multiple columns.
https://github.com/metabase/metabase/issues/708 - upvote by clicking :+1: on the first post

3

Thanks @flamber, do you know how I can do it using sql?

4

@leonardo96 Try searching the internet for a solution for your database type, since that is not specific to Metabase:
https://stackoverflow.com/questions/39945308/how-to-get-a-json-object-as-column-in-postgresql