SQL Query Node

A SQL Query node allows you to manually enter a SQL query with the least amount of constraints possible. This feature is expected to allow you to incorporate a much broader array of methodologies as part of a Data Miner workflow.

The output of a SQL Query node is a data flow.

The SQL Query node also allows you to run Oracle R Enterprise scripts that are registered for the database. See R Script Support for requirements and other information.

A simple use case for SQL Query node is to write a SQL Query that performs special data preparation. Use the SQL Query node to provide input for a model build.

The following topics describe SQL Query node: