Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
How do I execute th...
 
Notifications
Clear all

How do I execute the SQL query in the workflow. I want the data source to get updated.

2 Posts
2 Users
0 Likes
181 Views
Abhishek
(@abhishek)
Eminent Member
Joined: 11 months ago
Posts: 11
Topic starter  

I have created a SQL table and I want to update the data source with those details. How should I go about that?


   
Quote
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
 

Step 1: Click on the transformation tab.  

Step 2: Drag and drop the SQL node onto the main screen.

Step 3: Once you drop the node onto the main screen, a save popup appears. Enter the workflow name and click on the save button.

Step 4: Select the data source on the right side of your screen.  

Step 5: Once the data source has been selected, click on the query button to execute the query. 

Step 6: Upon clicking “Query”, a SQL Executor popup appears. 

Step 7: You can enter the Title, Type and Query. Multiple queries can be added by clicking on the add button on the right.  

Step 8: Click on Apply once the necessary inputs have been entered. (Refer to the image below). 

1693917228-sqlexecutepopup.png
Step 9: Click on the run button to run the SQL Executor node. Click on the Show Results button and the result is shown under the result tab. (Refer to the image below).  
1693917266-sqlresult.png
Note: The effect of the query executed above can be seen in the selected data source.
This post was modified 11 months ago 2 times by Nikhila

   
ReplyQuote
Share: