Database

Prev Next

Description

The Database source node imports data from a database table.


Configuration Options

Basic Configuration Options

Setting Description\Parameters
Database Connection The database to query against. This connection can be configured in Flow Connections.
SQL Dialect SQL language variant to use. Defaults to ANSI.
SQL Query to be run against the selected database connection.

Advanced Configuration Options

Setting Description
SQL Snippets Typing @ within the SQL editor prompts the user for several node-relevant snippets.
Parameters Typing # within the SQL editor prompts the user for a list of available parameters.

Actions

Action Description
Preview Once the node is configured, the source data can be previewed at any time.