This extract retrieves data from Azure Cosmos database services with SQL model/API. It allows selecting columns with aliases, filtering with WHERE clauses, and sorting.
|Connection||Connection of type CosmosDB|
||Available collections from Azure|
|Output Columns||Columns that should be returned by relational table extract|
|Logical Filter Expression||
A Boolean condition can be applied for if several filter conditions have been defined. Valid symbols are: [0-9] ( ) AND OR NOT
If no logical filter expression is defined an AND filter is applied, i.e. 1 AND 2 AND … AND n.
|Sorting||Ascending or descending order of the entered column.|
An optional part of a SQL query with additional options that are appended to the generated SQL statement.
Memory, disk or none (default). See article Caching in Extracts.
Note: CosmosSQL does not support the following functions: LIKE, HAVING, DISTINCT, MULTIPLE ORDER-BY, GROUP BY and AGGREGATE.