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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive