Replacing Flat Files with Database Tables

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

Goal: Working with flat files has become unmanagable for a flow. Update the flow to use database tables instead.


High-level Task: We're given a flow file that's performing some work on flat files. Swap any nodes that reference flat files with nodes that use database tables.


Detailed Task:

  1. Open the .flx flow.

NOTE: The first source file () has been replaced by the table . Any other intermediate tables will need to be created.

  1. Write a SQL query to only pull data in the shape of the flat file