Flatten relational data for import?

patrickj · 2023-11-20T22:31:12+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

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.

All comments

MarkSnodgrass

patrickj

Thanks for the advice Mark

ellibot

patrickj

Thanks @ellibot I'll check them out.