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. 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.
catalogProjectId - stringrequired
Analytics catalog project ID.
Default: fusion
queryText - stringrequired
The SQL query to execute. Replaceable parameters will be applied before query execution using values pulled from request parameters and the pipeline context.
contextKey - string
The key used to bind query results into the pipeline context; if not set, the query results are returned to the client.