SQL Executer

This node runs the given SQL query

Input

This type of node takes the sql query of any statement type

Output

This node executes the given SQL query

Type

dataset

Class

fire.nodes.runrdbmssql.NodeSqlExecuter

Fields

Name	Title	Description
url	Db Url	URL of SQL
driver	driver class name	driver class name for SQL
user name	User Name	User name of SQL
password	password	password of SQL
statementType	Statement Type	statementType of SQL
query	query	query to execute

Details

SQL Executor Node

This node executes a specified SQL query against a database. The results of the query are returned as a DataFrame.

Examples

SQL Executor Node Example

Given a database table named customers with the following schema:

Column Name Data Type

customer_id INT

customer_name STRING

customer_email STRING

To retrieve all customers with the email domain example.com, you can use the following SQL query in the SQL Executor node:

SQL

SELECT * FROM customers WHERE customer_email LIKE ‘%@example.com’;

The output of this query would be a DataFrame containing the selected customer information.