execute volatile table within KNIME


I have successfully created and run a volatile table within the KNIME database reader node. example below:

create volatile table temp_event as
SELECT event_date, event_type
FROM event_table
) with data on commit preserve rows;

SELECT * from temp_event;


however, when I reset the node and try to re-execute it, i always get an error stated that the Table 'temp_event' already exists. I always need to close the KNIME analytics platform before able to re-create the volatile table.

Is there a way to drop/reset the connection and create a new connection from KNIME to the database (we use teradata)?

Hi pkusuma,

You could try to use the "Database Drop Table" node to drop the volatile table, after the Database Reader has executed.

Hope that helps,