Explain to me Dataflow Input/Transform/Output
Hi there, I am watching your video on Dataflows and I would like to know more about the process.
I see that you have input, transformaiton and output.
I am confused because Transformaiton and Output are esentually the same. I could write an SQL statement that joins two tables together and gives an output. I am a little confused as to where I would put the join statement.
Would I just put the join statement in the transformation and then in the output just type
Select * from table; ?
Comments
-
Does anybody have any insight to @stevenmorey's question?
0 -
Hello,
Yes you are correct about the "Select * " Statement.Your use of transformations over going directly to the output table is moreso about personal organization. While you can use joins in both segments I'd suggest doing the dirty work in transformation tables. Make sure you select 'Generate Output Table' at the bottom of the transformation dialog box. You won't select 'Generate Output Table' when you are altering tables or adding indicies. Those instances are where Transformations are most employed.
2 -
@stevenmorey, did swyatt's explanation answer your question?
0 -
Use the transforms to effectively create views of the data that you can use for following transform steps.
When you have the data in final transform, you can use the output to create a data source. What I've typically seen is that you will use your final transform step (this could be a single step, or at the end of multiple) as a view that you can select * from in your output table.
This output becomes your data source, and is visible in the data source section of the data center.
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