Can you use a Datafusion dataset in Magic ETL as an Input data source?
I am trying to join two tables and they will not produce any results in the Magic ETL, But the join works in the Datafusion.
Can we use the Datafusion as a Data input in the Magic ETL?
Best Answer
-
Currently it's not possible to have a DataFusion dataset as an input to Magic ETL. The reasoning, without getting to technical, is that a DataFusion is essentially only creating a view or "description" of how datasets should be joined, without actually running any calculations or physically creating a new dataset. When a card is built on a DataFusion dataset, the data is then calculated "on the fly" or as needed. Because no physical dataset is created, it can't be an input to Magic ETL or DataFlows. There is potential to make this work in the future (i.e. being able to say, "create an actual new dataset from this datafusion"), but nothing like that currently.
3
Answers
-
Currently it's not possible to have a DataFusion dataset as an input to Magic ETL. The reasoning, without getting to technical, is that a DataFusion is essentially only creating a view or "description" of how datasets should be joined, without actually running any calculations or physically creating a new dataset. When a card is built on a DataFusion dataset, the data is then calculated "on the fly" or as needed. Because no physical dataset is created, it can't be an input to Magic ETL or DataFlows. There is potential to make this work in the future (i.e. being able to say, "create an actual new dataset from this datafusion"), but nothing like that currently.
3 -
yes, thank you
1 -
"There is potential to make this work in the future (i.e. being able to say, "create an actual new dataset from this datafusion"), but nothing like that currently."
Currently sitting in the Data Manipulation class at Domopalooza. Everyone agrees this is a much needed feature.
1 -
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
- 748 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
- 125 Manage
- 122 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