Hub
NodeNode / Other

SQL Extract (legacy)

DB Database (legacy) Utility (legacy)
Drag & drop
Like
Copy short link

This node is part of the legacy database framework and will be deprecated at the end of 2022. For more information on how to migrate to the new database framework see the migration section of the database documentation .

This node extracts the SQL query from a database port and creates a flow variable and data table containing the query.

Node details

Input ports
  1. Type: Database Query
    Database Port
    A database port with a connection and a query
Output ports
  1. Type: Flow Variable
    SQL query flow variable
    The SQL query as a flow variable
  2. Type: Table
    SQL query table
    The SQL query as a string cell in a table with 1 row and 1 column.

Extension

The SQL Extract (legacy) node is part of this extension:

Related workflows & nodes