Query
Overview
Query is a source type that represents a source defined by a query rather than a named table or view.
Function
Use this type when source rows require custom selection, joins, or calculations at the source. Selecting it executes the maintained query to produce source rows.
When to use
Choose Query when source rows require custom selection, joins, or calculations at the source.
Behavior in AnalyticsCreator
| Area | Behavior |
|---|---|
| Configuration | Configure the connector, query statement, and resulting column metadata. |
| Processing | AnalyticsCreator submits the query through the connector and reads the result set. |
| Output | The source exposes the query result as a reusable AnalyticsCreator source. |
Type-specific properties
| Property | Description |
|---|---|
| Query | Statement used to produce the source rows. |
| Columns | Result columns maintained for the query source. |
| Parameters or filters | Optional values supported by the connector or source definition. |
| Timeout | Execution timeout where configurable. |
Compatibility and limitations
The query must be valid for the source platform and may require manual metadata maintenance.
Relationships
| Related entity | Relationship |
|---|---|
| Source | The source type identifies how the source definition obtains its rows. |
| Connector | The connector determines which source types and source objects are available. |
