SQL Block
The SQL Block enables users to write and execute Structured Query Language (SQL) directly within nodes, allowing data retrieval without relying on predefined data actions.
Users can execute SQL queries by establishing connections between nodes, streamlining the querying process and enhancing workflow efficiency.
The SQL Block supports basic SQL queries, enabling faster data retrieval with efficient querying capabilities.
SQL Block Configuration
Follow these steps to configure and execute SQL queries effectively:
1. Write Your SQL Query
The primary configuration box allows users to input custom SQL queries.
Input Options:
Manually Input Query – Users can directly type the SQL query in the input field.
Preview Available Columns – Users can view a list of columns from the source data, making it easier to select the correct fields.
2. Validate the Query
Before execution, users can validate the query using the Validate button.
This step ensures that the SQL query is syntactically correct and ready for execution.
Validation helps identify common syntax issues and potential errors in the query.
3. Execute the Query
Once validated, users can execute the query to retrieve data from the connected source.
The query results are displayed in the output section, based on the executed query.
This enables users to efficiently extract the necessary data into their workflow.