Does Domo have the equivalent of a SQL Server "View"?
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?
Best Answers
-
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
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
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
2
Answers
-
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
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
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
2 -
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?
0 -
My understanding is that they do not as it's not actually storing any rows.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 966 Connectors
- 254 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 75 SQL DataFlows
- 499 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 360 Beast Mode
- 19 Variables
- 483 Automate
- 101 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive