Microsoft SQL Server and Azure SQL Database Non-Spatial (JDBC) Reader: Feature Type 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.
All feature types share similar General Parameters. This includes Name and Writer Name. From here, you can also control Dynamic Properties.
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.
Table Settings
To construct a WHERE clause, click the browse button to open the Where Clause editor. You can also type in a WHERE clause inline.
If the WHERE clause SQL is invalid, the translation will fail.