Does Domo have the equivalent of a SQL Server "View"?

JunkDoom · January 2022

Maybe I've spent too many years deep in SQL Server.

SQL Server has the concept of a "View", which is really just a query, usually containing a join. Instead of having to write a query to join tables, I can just query the view without needing to know the underlying relationships. I don't see any equivalent in Domo that allows this abstraction. I realize that I can set up ETL data flows to create new "joined" data sets, but is that really the expected way to work with data? Build data flows for every relationship?

GrantSmith · January 2022

Hi @JunkDoom

Domo does have DataSet Views which function similar to database views. You can read more about them here: https://domohelp.domo.com/hc/en-us/articles/360046074774-DataSet-Views

MichelleH · January 2022

Hi @JunkDoom yes, Domo has a relatively new feature called DataSet Views that allows simple joins and transformations. You can read more about it here: https://domohelp.domo.com/hc/en-us/articles/360046074774-DataSet-Views

mhouston · January 2022

@JunkDoom I asked my CSM this same question and he confirmed it doesn't count against our row limit since they aren't materialized. You will still see them counted as part of your row count in the domo warehouse though.

GrantSmith · January 2022

Hi @JunkDoom

Domo does have DataSet Views which function similar to database views. You can read more about them here: https://domohelp.domo.com/hc/en-us/articles/360046074774-DataSet-Views

MichelleH · January 2022

Hi @JunkDoom yes, Domo has a relatively new feature called DataSet Views that allows simple joins and transformations. You can read more about it here: https://domohelp.domo.com/hc/en-us/articles/360046074774-DataSet-Views

JunkDoom · January 2022

Great! This is exactly what I need. However, there is no mention of how row count affects licensing. Do row counts in views count against our licensing or are these 'free' since they're just a join of existing data sets?

GrantSmith · January 2022

@JunkDoom

My understanding is that they do not as it's not actually storing any rows.

mhouston · January 2022

@JunkDoom I asked my CSM this same question and he confirmed it doesn't count against our row limit since they aren't materialized. You will still see them counted as part of your row count in the domo warehouse though.

Does Domo have the equivalent of a SQL Server "View"?

Best Answers

Answers

Categories