Reply
Highlighted
Visitor
Posts: 4
Registered: ‎10-19-2016

Support for Postgres HSTORE and JSON data types

[ Edited ]

Hi,

 

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?

 

Thanks,

Stan

Moderator
Posts: 260
Registered: ‎09-19-2016

Re: Support for Postgres HSTORE and JSON data types

Hi all,

Can anybody help out @stanjackson?

Thanks!

Announcements
Domo Dojo Day is May 4th! Mark your calendars for the next Domo Dojo Day! To learn more click here! Thanks!