Database Data

Database data components provide direct access to SQL databases and structured data sources for data retrieval and processing.

SQL Query

This component connects to SQL databases and executes queries to retrieve structured data.

Usage

The SQL Query component enables:

• Direct database connectivity

• Custom SQL query execution

• Structured data retrieval

• Database integration workflows

• Real-time data access

Inputs

Name	Display Name	Info
database_url	Database URL	Connection string for the database
query	SQL Query	SQL query to execute
parameters	Parameters	Query parameters for prepared statements

Outputs

Name	Display Name	Info
data	Data	Query results as structured Data objects
dataframe	DataFrame	Query results as DataFrame format

Usage Notes

• SQL Compatibility: Support for various SQL database systems

• Parameterized Queries: Safe query execution with parameter binding

• Structured Output: Results returned as both Data objects and DataFrames

• Connection Management: Efficient database connection handling

• Error Handling: Robust error reporting for debugging

• Security: Built-in protection against SQL injection attacks