Flat Files to a Database

  • Updated on Dec 23, 2022
  • 1 minute(s) read
Prev Next

Goal: Create a database table from a flat file.


High-level Task: Given a .csv file, create a new database table. This table should have all the data from the flat file 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 Flat File source node to the canvas. Open the Iris.csv file.
  4. Add a Database export node to the canvas. Attach the Flat File source node to this node.
  5. Configure the export node to create a new table named -Iris, preceeded by your initials. Run the node.
  6. Add a Database source node to the canvas. Run the following query (with the correct table name) to preview the data: SELECT * FROM IRIS