Snowflake Reader Feature Type Parameters
|
To access feature type parameters, click the gear icon Tip To always display the editor in FME Workbench, you can select View > Windows > 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. |
These parameters apply only to a selected feature type, not to the entire reader.
Constraints
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.
in the WHERE Clause editor.If enabled, the reader will use a COPY INTO <location> command. The copy location will be set to a temporary directory in the current user’s stage (which can be referenced via @~).
This mode allows larger volumes of data to be read without timing out, but may harm performance for smaller datasets.
If fatal issues were encountered during the reading process, FME will attempt to cancel the COPY INTO command (if the command is not yet finished) and delete the temporary directory from the user stage. However, if the attempt fails, a manual clean up may be required.
To manually cancel the COPY INTO command, do the following:
- Obtain query ID of the COPY INTO command. In most cases, this can be found in the translation log: “COPY INTO query was successfully started with ID: ...”. Otherwise, refer to the query history in the Snowflake web console.
- Run the following query, replacing [query_id] with the ID obtained in the previous step:
SELECT SYSTEM$CANCEL_QUERY(‘[query_id]’)
To manually remove the temporary directory, do the following:
- Obtain the path of the temporary directory. This can be found in the translation log: “Setting temporary stage location for bulk reading to: …”
- Run the following query, replacing [temp_path] with the path obtained in the previous step:
REMOVE [temp_path]
In Bulk Reading mode, this parameter will specify whether to read Variant columns as JSON (default) or XML.
on a feature type in the