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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive