We have some jsonb columns in our postgres database that Metabase is parsing and exposing as model properties, which is very useful. However, it appears that some properties are missing... is there a way to get them to show up? Either by declaring them manually in the model or forcing a scan of all the rows in the table? Thanks.
I have had many similar experiences. My workaround was to parse the json manually in a sql query, make that question into a model and use that to build successive questions.
Maybe the automatic parsing has a hard time understanding nullable jsonb columns. Cause this problem only impacts me in tables where the jsonb column has null values