when should we use data fusion over etl data flows
Best Answer
-
Fusion is fantastic for relatively simple joins on large datasets that number in the tens of millions of rows and greater.
The ETL and MySQL dataflows are different ways to accomplish the same end goal, allowing the user to pick the method they are most comfortable with. Some users work best in SQL, so the MySQL ETL recreates that, whereas some people prefer visual drag and drop dataflows which is Magic ETL.
All things being equal, I believe that Magic ETL is slightly more performant than MySQL ETL however.
The choice further comes down to how complicated some of your dataflows are/can be, and how they will be managed. It's easier to see what's happening from a high level with Magic, but can data transformations tricky to perform. MySQL allows for basically any data transformation to occur, but you need to go into each transform to view the logic.
0
Answers
-
Fusion is fantastic for relatively simple joins on large datasets that number in the tens of millions of rows and greater.
The ETL and MySQL dataflows are different ways to accomplish the same end goal, allowing the user to pick the method they are most comfortable with. Some users work best in SQL, so the MySQL ETL recreates that, whereas some people prefer visual drag and drop dataflows which is Magic ETL.
All things being equal, I believe that Magic ETL is slightly more performant than MySQL ETL however.
The choice further comes down to how complicated some of your dataflows are/can be, and how they will be managed. It's easier to see what's happening from a high level with Magic, but can data transformations tricky to perform. MySQL allows for basically any data transformation to occur, but you need to go into each transform to view the logic.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 763 Beast Mode
- 65 App Studio
- 42 Variables
- 709 Automate
- 184 Apps
- 460 APIs & Domo Developer
- 54 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 134 Manage
- 131 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive