Databricks Reader Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace. This opens the Feature Type Parameter Editor.

Tip  To always display the editor in FME Workbench, you can select View > Window Layout > Parameter Editor.

General

All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry.

In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type.

Important  These parameters apply only to a selected feature type, not to the entire writer. If a feature type parameter listed here conflicts with a writer-level parameter, then the writer parameter will be ignored and this feature type parameter will be used.

Table Settings

The WHERE clause parameter is used to constrain the row selection in tables chosen in the Tables parameter. FME will select only the rows (records) that match this condition.

The easiest method to construct a WHERE clause is by using the editor. Click the browse button (...) to open the editor, and use the SQL functions to construct the clause.

You can also type a WHERE clause directly in the parameter field:

Examples

When querying integer and number data types:

NUMLANES = 2

LENGTH > 2000

If the WHERE clause SQL is invalid, the translation will fail.

Tip  For assistance with constructing WHERE clauses, click the AI Assist button in the WHERE Clause editor.

When checked, this parameter enables reading previous versions of the table based on timestamp or version number.

Table History Method

Select either Timestamp or Version to determine which previous versions of the table to read.

Timestamp

Specify a timestamp. A date picker widget is available as part of the dropdown.

Note   Time values can be changed manually and milliseconds are supported by entering values after a decimal.

The timestamp must be in the format yyyy-mm-dd hh:mm:ss.SSS

Version

Specify a version number.