Flatten relational data for import?

patrickj

Hi,

First time using Domo. I have a highly relational database with about 20 tables in postgresql.

Should I flatten these tables in pgsql before importing to Domo or should I be importing all 20 tables and doing the joins in Domo?

What is best practice.

Thanks

MarkSnodgrass

Most people will flatten with a view or a query that joins tables together to cut down on the number of jobs that are running. It will also reduce the number of dataset and dataflow executions, if you need to worry about that from a cost consumption perspective.

ellibot

@patrickj I'd also recommend trying out Domo's Dataset Views feature: https://domo-support.domo.com/s/article/360046074774?language=en_US

Definitely depends on your use case in terms of flattening tables before Domo or inside Domo. If you find your pgsql connectors are running very slowly, I'd recommend doing fewer joins in the connector itself and instead try dataset views.

MarkSnodgrass

Most people will flatten with a view or a query that joins tables together to cut down on the number of jobs that are running. It will also reduce the number of dataset and dataflow executions, if you need to worry about that from a cost consumption perspective.

patrickj

Thanks for the advice Mark

ellibot

@patrickj I'd also recommend trying out Domo's Dataset Views feature: https://domo-support.domo.com/s/article/360046074774?language=en_US

Definitely depends on your use case in terms of flattening tables before Domo or inside Domo. If you find your pgsql connectors are running very slowly, I'd recommend doing fewer joins in the connector itself and instead try dataset views.

patrickj

Thanks @ellibot I'll check them out.