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




      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?