Input · Folders and loops

DB Directory

Lists the tables in a database connection, one row per table, so a loop can run once per table. You can filter the list by name.

Also known as: Table per record

How it works

Add the source from Add data source → Database and tick Enumerate tables. The node lists the user tables of the connection, one row per table with schema and table. Table filter (optional) keeps only the tables whose schema.table contains the text, case-insensitively; blank lists every table. Wire it into a Loop's items port and bind a DB Reader's Table inside the loop to the table column.

Inputs and outputs

Settings

Nothing to set in the Attributes panel: see How it works for where this node is set up.

Example

Archive every table in the sales schema to Parquet: Table filter sales., then a loop with a DB Reader bound to table and a Write Parquet whose file name uses the same column.

More in Folders and loops

• Directory — Lists the files in a folder, one row per file, instead of reading their rows. Wire it into a loop to process every file in turn.
• S3 Directory — Lists the objects in an S3 location that match a pattern, one row per object, so a loop can process each one.
• Sheets — Lists the sheets of an Excel workbook, one row per sheet, so a loop can read each sheet in turn.
• Current item — Sits inside every loop and gives you the item the loop is on right now, such as the current file read as a table. It is added for you and can't be removed.
• File — Reads the file whose path sits in a column of its input: Parquet, CSV, JSON, Excel or a map file, on disk or in S3. Wire a loop's Current item into it to read a different file each time.