Contents x
    Replacing Flat Files with Database Tables
    • 23 Dec 2022
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Replacing Flat Files with Database Tables

    • Updated on 23 Dec 2022
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    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
    Was this article helpful?
    What's Next