Question

add dimensions as they appear in JSON column

  • 13 October 2021
  • 1 reply
  • 22 views

We’ve got a JSON column with varied and often-changing keys. I want each of those keys to be a dimension.

 

What I do now is run a query that produces, as output, one key per row, and I use that and an offline script to generate the LookML. The query looks back on all of history to make sure I include all the JSON keys we’ve ever used. I then copy-paste the generated LookML instead of the old version into Looker.

 

The problem is that querying so much history every time is inefficient. I’d rather add to a list than replace it.

 

I seek a solution for this.  My idea is to add to a PDT and then somehow get that PDT to automatically become a list of dimensions (perhaps using Liquid?), but I’ve no idea how to do that latter.

 

Any suggestions, please?


1 reply

(I posted this previously but somehow that got closed to answers, which obviously won’t help me if someone comes along with an idea, so I’ve posting it again now.)

Reply