Do not Generate Output Table in transformation not available
Hello,
I'm looking how to not Generate an Output Table in a transformation ? I did not have this option neither in the transformation neither the dataflow.
In lot of tutorial, I saw that a pop up appear with : MagicETL, MySQL and Redshift and then in the editor there is a dropdown list with thoses 3 same options.
I did not have this, I have only Magic Transform : Blend, ETL, SQL, R Plugin.
Somebody else have the same issue or a way how to not generate an output table ?
Thank you for your help,
Philippe.
Best Answer
-
You want to use the SQL option. You can then click on "+ADD TRANSFORM" and select the SQL option. This will allow you to write SQL code that does not create an output table. However, in order to save the dataflow, you will still need to create an output for the data flow. This single transform will not create a new table though.
Not sure if that is what you are looking for or not. Let me know if you had a different question.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Answers
-
You want to use the SQL option. You can then click on "+ADD TRANSFORM" and select the SQL option. This will allow you to write SQL code that does not create an output table. However, in order to save the dataflow, you will still need to create an output for the data flow. This single transform will not create a new table though.
Not sure if that is what you are looking for or not. Let me know if you had a different question.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Thank you Superman ! That is excatly what I was looking for in order to create stocked procedure in domo.
Have a nice day,
Philippe.
0 -
thanks Superman,
"This will allow you to write SQL code that does not create an output table. However, in order to save the dataflow, you will still need to create an output for the data flow." but I don't know how to call the Transforms-SQL when I setup query to create output for my dataflow (if Transforms-Table, I can just select from the Table name, but I don't know how to get from Transform-SQL). Could you or anyone please teach me?
thank you!
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