Nested joins in Data Fusion
Can someone please help me to understand how to build nested joins using Data fusion? Should the links be added in a single data fusion or should i use nested data fusion?
Comments
-
Hi @user052647, I'd imagine you already had a look through this knowledge article: https://domohelp.domo.com/hc/en-us/articles/360043428293-Combining-DataSets-Using-DataFusion. What was the specific case you were trying to address?
6 -
You should probably stop using Fusions and switch over to using Data Set Views as soon as reasonable.
Fusions and DSVs use the same technical underpinnings, so I like to frame DataSet Views as an improved UI for Fusions.
With DSVs you can JOIN Fusions on Fusions. Keep in mind a Fusion is the same as a VIEW in a SQL database, so nesting VIEWs can have performance implications at massive scale. For smaller datasets (particularly when you're compressing your row count with a GROUP BY clause, Domo's database layer (Adrenaline) seems to cope pretty well.
If you have performance problems you can always refer to Domo support and they can do some behind the scenes engineering.
If you want to get nerdy about it, I cover some of the performance optimization stuff in this video:
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as 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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive