|Specifies the Controller Service to use for parsing incoming data and determining the data's schema|
|Record Writer||Controller Service API: |
|Specifies the Controller Service to use for writing results to a FlowFile|
|Include Zero Record FlowFiles||true||When running the SQL statement against an incoming FlowFile, if the result has no data, this property specifies whether or not a FlowFile will be sent to the corresponding relationship|
|Cache Schema||true||Parsing the SQL query and deriving the FlowFile's schema is relatively expensive. If this value is set to true, the Processor will cache these values so that the Processor is much more efficient and much faster. However, if this is done, then the schema that is derived for the first FlowFile processed must apply to all FlowFiles. If all FlowFiles will not have the exact same schema, or if the SQL SELECT statement uses the Expression Language, this value should be set to false.|
Dynamic Properties allow the user to specify both the name and value of a property.
|The name of the relationship to route data to||A SQL SELECT statement that is used to determine what data should be routed to this relationship.||Each user-defined property specifies a SQL SELECT statement to run over the data, with the data that is selected being routed to the relationship whose name is the property name|
Supports Expression Language: true (will be evaluated using flow file attributes and variable registry)
|failure||If a FlowFile fails processing for any reason (for example, the SQL statement contains columns not present in input data), the original FlowFile it will be routed to this relationship|
|original||The original FlowFile is routed to this relationship|
A Dynamic Relationship may be created based on how the user configures the Processor.
|<Property Name>||Each user-defined property defines a new Relationship for this Processor.|
Reads Attributes: None specified.
|mime.type||Sets the mime.type attribute to the MIME Type specified by the Record Writer|
|record.count||The number of records selected by the query|
State management: This component does not store state.
Restricted: This component is not restricted.
Input requirement: This component requires an incoming relationship.
System Resource Considerations:None specified.