01-05-2017 08:28 AM - edited 01-05-2017 08:29 AM
I am new to Domo.
My company provides a multi-tenant SAAS service and we support custom fields on a per client basis.
Our implementation uses the Postgres HSTORE data type (similar to JSON, large text field with key-value pairs).
So, data for one client may include data with keys 'fruits' and 'vegetables' where another client may include data with keys 'trains', 'planes', and 'automobiles'.
The Postgres connector converts hstore data types to string. For example, the custom_field data will look something like this:
Now, if I want to import data for a specific key, I can include something like
select .... custom_field->'fruits' as fruits
Is there any way in Domo to make procesing this data easier?
Ideally, I would love to be able to directly import hstore data and to subsequently build Magic ETL's or beast mode calculations to pull out specific keys.
Failing that, is there a clever beast mode calculation that makes this easier?