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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 737 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive