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

JunkDoom

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

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

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

@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

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

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

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

@JunkDoom

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

mhouston

@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.