convert a jason into a relational table in snowflake

I want someone convert a jason file currently residing in snowflake as variant column , parse it , pull all the information till the leaf level arrays.