Semi-Structured columns in DQ mode

[GriRim]

Hi folks,

I just wondering if it's a way to parse the data from semi-strucured colums (Snowlake) in Direct Query mode.

I know how to do in import but can't find a way to do this in DQ mode.

Have anyone tried this?

Example of column value:

Thanks in advance!

[Syndicate_Admin]

use SUBSTITUTE, PATH and Modulo.