Sql Lookup
Enrich documents with SQL query results from external databases
Configuration
REQUIRED. Organization connection ID or name.
REQUIRED. SQL SELECT query (mutations blocked). Use $1, $2 for parameters.
Named parameters for SQL query. Values support {{DOC.*}}, {{INPUT.*}} templates.
Dot-path where SQL results are stored.
How to handle multiple rows: 'first', 'all', 'error_if_empty', 'error_if_multiple'.
Query timeout in seconds (1-300).
Error handling: 'skip', 'remove', or 'raise'.
Output
No output yet
Configure the stage parameters and click "Run Stage" to see the simulated output.
Related to sql_lookup
Pages on the same stages, extractors and patterns.
Json Transform
Transform documents using Jinja2 templates that render to JSON
Rag Prepare
Prepare documents for LLM context windows with token management
External Web Search
Enrich documents with web search results using Exa AI
Api Call
Enrich documents with external API calls
Llm Enrich
Enrich documents with LLM-generated fields using natural language prompts
Taxonomy Enrich
Classify documents against taxonomy nodes via vector similarity