Between Tables

Goal: Create a database table from another table.

High-level Task: Given a DB table, create a new database table. This table should have all the data from the original table in the same format. Preview it with a database source node to verify the data can be queried elsewhere.

Detailed Task:

1. Create a new flow.
2. Add a new database connection.
3. Add a Database source node to the canvas. Run the following query (with the correct table name) to select all records: SELECT * FROM IRIS
4. Add a Database export node to the canvas. Attach the Database source node to this node.
5. Configure the export node to create a new table named -IrisRenamed, preceeded by your initials. Run the node.