Allow access to fields of unstructured data in filters and custom expression

dacort / metabase-athena-driver

An Amazon Athena driver for Metabase 0.32 and later

Apache License 2.0

225 stars 32 forks source link

Allow access to fields of unstructured data in filters and custom expression #77

Closed FranzBusch closed 1 year ago

FranzBusch commented 3 years ago

I have a column that contains unstructured JSON data. Would it be possible to access these nested fields in the filters and custom expressions somehow?

dacort commented 3 years ago

I'm not sure about native filters (Metabase would have to add support for JSON data first).

A couple potential workarounds using json_extract:

Create a view in Athena with the desired fields extracted from the JSON
Use SQL to extract the fields and then create filters on that SQL question

FranzBusch commented 3 years ago

I opted to create a view in Athena for now. Let's see if Metabase adds support for this in the future.

dacort commented 1 year ago

Closing as part of cleanup now that Athena is officially supported by Metabase.

See https://github.com/metabase/metabase/issues/26972 for a similar issue.