How can i write data to CSV file while i am processing using node “DB SQL Executor” and creating a volatile table in it. Now i want to write data processed in DB sql executor to a CSV . DB SQL executor doesnt connect to CSV writer.
What is the solution
Hi @rds, when you say you are “creating a volatile table” in the DB SQL Executor, I think this means within that node you are probably creating the table and then inserting data into it. Is that right?
In which case, I would think you can simply attach a DB Query Reader node to the DB SQL Executor and write something like
select * from MY_VOLATILE_TABLE
then attach the output of that to the CSV Writer.
If that doesn’t help, can you describe more, or give an example of what your DB SQL Executor is doing