Microsoft Azure Cosmos DB (DocumentDB) Reader: Format Parameters
To access feature type parameters, click the gear icon on a feature type in the workspace to open the Feature Type Parameter Editor. To always display the editor in Workbench, you can select View > Windows > Parameter Editor.
General
All feature types share similar General parameters, including the Feature Type Name, Reader or Writer Name, and Geometry.
In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept a Table Qualifier prefix on the output table feature type.
See Editing Writer Feature Types for more information.
These parameters apply only to a selected feature type, not to the entire reader.
Note: If a feature type parameter corresponds to a reader-level parameter, then the reader parameter will be ignored and the feature type parameter will be used.
Optional. This parameter constitutes the WHERE clause of the SQL query to execute against the Collection. The value is passed as-is, with no validation.
If not specified, all Documents in the Collection are read.
Note: All property (column) names must be prefixed with root. For example, to filter on the id property, the WHERE clause must be root.id = ‘foo’, not id = ‘foo’.
For details on how to build WHERE clauses for DocumentDB, see https://azure.microsoft.com/en-us/documentation/articles/documentdb-sql-query/#where-clause.
Document Options
Optional. If the specified property exists on a Document, and its value is GeoJSON, the DocumentDB Reader will parse the GeoJSON and include it as geometry on output features .
Default: geom