Posts: 4
Registered: ‎10-19-2016

Support for Postgres HSTORE and JSON data types

[ Edited ]



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:

"fruits"=>"applest", "vegetables"=>"peas"

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?


Or is there a javascript or python plugin that can be installed to handle this?




Posts: 260
Registered: ‎09-19-2016

Re: Support for Postgres HSTORE and JSON data types

Hi all,

Can anybody help out @stanjackson?


Domopalooza 2018 Call for Presenters! Do you have an amazing story about how Domo is revolutionizing the way you do business? Click here for more details! Thanks!