How I Can spliting JSON in columns

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

Hi @leonardo96
You should really consider upgrading a some point:
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. - upvote by clicking :+1: on the first post

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

@leonardo96 Try searching the internet for a solution for your database type, since that is not specific to Metabase: