JSON unfolding not activating

Json folding is enabled in the database however the specific field doesnt have an option for JSON unfolding. However the field does have "Field containing JSON". Is this because each row for the JSON column has to have a value of {} rather than be blank. As some of the value for that column dont always have a value (nil in the application database).

{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.22+7",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.22",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.22+7",
"os.name": "Linux",
"os.version": "5.10.210-201.852.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"h2",
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.17"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.7.2"
}
},
"run-mode": "prod",
"version": {
"date": "2024-04-22",
"tag": "v0.48.12",
"hash": "af4e2ec"
},
"settings": {
"report-timezone": null
}
}
}

Update: The JSON unfolding option has appeared and set to "Yes", field has been rescanned and cache discarded, however the columns have not been split.

Please confirm what further action is required or what the potential issue may be?

I am having an issue where 'Unfold JSON' doesn't show up in Table Metadata -> (column) Field settings

but i do see the Allow unfolding of JSON columns option in Databases tab.

did you ever find a solution?

@chammar - you cannot manage the unfolding setting on the fields until after you have enabled it on the database itself.

@lucasmoj do you see any errors in the logs?

Thank you I figured it out !

1 Like