Analytics Catalog Stage
The Analytics Catalog query pipeline stage lets you define views of data stored in Fusion collections. You can query the objects in the Analytics Catalog using SQL, Solr Streaming Expressions, or regular Solr queries. See also the Catalog API.
|
|
When entering configuration values in the UI, use unescaped characters, such as \t for the tab character. When entering configuration values in the API, use escaped characters, such as \\t for the tab character.
|
Query objects in the Fusion Analytics Catalog using SQL, Solr Streaming Expressions, or Solr queries. The Fusion Analytics Catalog allows you to define views of data stored in Fusion Collections. You must start the Fusion sql service before using this stage.
skip - boolean
Set to true to skip this stage.
Default: false
label - string
A unique label for this stage.
<= 255 characters
condition - string
Define a conditional script that must result in true or false. This can be used to determine if the stage should process or not.
queryType - string
Query type: solr, sql, or streaming_expression
Default: sql
Allowed values: solrsqlstreaming_expression
catalogProjectId - stringrequired
Analytics catalog project ID.
Default: fusion
queryText - stringrequired
Query to execute; accepts any valid Solr query, SQL, or Solr streaming expression. Replaceable parameters will be applied before query execution using values pulled from request parameters and the pipeline context.
requestHandler - string
The Solr request handler to send a query to; only applies if query type is 'solr' or 'streaming_expression'. Defaults to /select for solr queries and /stream for streaming expressions.
contextKey - string
The key used to bind query results into the pipeline context; if not set, the query results are returned to the client.
params - array[object]
object attributes:{key required : {
display name: Parameter Name
type: string
}value : {
display name: Parameter Value
type: string
}}