4 Replies Latest reply on Dec 9, 2019 3:55 PM by Daniel Cory

    Parsing MySQL columns of JSON type

    John Taylor

      I have a table that has a JSON field.

       

      In a MySQL query I can create different columns for the different key values in the JSON field using the metadata function as follows:

       

      metadata->'$.keyA' as field_A,

      metadata->'$.keyB' as field_B

       

      etc.

       

      Tableau executes this query with no errors when building the datasource, but the fields do not show up.

       

      Is there a way around this or another function I can use to parse out the information?

       

      Thanks