How-to guideApplies to: Unified engine deployments
Register a temporary file view and query the selected input.
Before you start
Prepare a file containing newline-delimited JSON objects such as
{“order_id”:1,“amount”:12.5} and {“order_id”:2,“amount”:7.5}.
The files must already exist under a configured local file-source root. Use the
path visible to the engine and workers, rather than a path that exists only on
your laptop. See
file-source configuration.
Values to collect
- Absolute configured file path, or folder path for the filter recipe.
Run the SQL
Replace every <placeholder> before running. Use unused names for the resources
below. Run the statements in order in Workbench.
Check the result
The SELECT should show the prepared order_id and amount fields. For the two-row
examples, expect values (1, 12.5) and (2, 7.5), in any order. For a folder read,
only matching CSV inputs should contribute rows.
Clean up
Drop the temporary view. Input files stay in place.
Last modified on November 4, 2026
