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. These connections can be configured through the guide at Flow Connections. |
SQL Dialect |
SQL language variant to use. Defaults to ANSI. |
SQL |
Query to be run against selected database connection. |
Advanced Configuration Options
| Setting |
Description |
SQL Snippets |
Typing @ within the SQL editor will prompt the user for a number of node relevant snippets. |
Parameters |
Typing # within the SQL editor will prompt the user for a list of available parameters. |
Actions
| Action |
Description |
Preview |
After configuring the node, the source data can be previewed by clicking the Preview button. |