Templates
Pre-built Transformation Builder workflows for common Navixy transformations. Download, import, and adapt them to your scenario
Navixy provides workflow templates for common transformations available in the Transformation layer. Each template is a pre-built Transformation Builder workflow configuration that you can import, inspect, and adapt to your operational scenario before scheduling it as a custom transformation in processed_custom_data.
Templates are a starting point, not a finished product. Every template ships without an Output node so you can decide where and how results are written before committing to a schedule.
How to use a template
The steps below apply to any template on this page. Template-specific values for the Output node and schedule are listed in the Available templates section.
Download the template
Find the transformation you want in the Available templates section below and download its YAML file.
Open Transformation Builder and connect to your database
Launch Transformation Builder and enter your PostgreSQL connection URL. Wait for the Builder to discover available tables and columns.
Import the workflow
Click Import in the toolbar and select the downloaded .yaml file. The workflow graph loads with all nodes and edges in place.
Review and adjust the workflow
Inspect the node graph. Each transformation's page in Common transformations describes the processing logic and lists customization options you can apply at this stage. Click Execute at any point to preview results against your live data (up to 100 rows).
Add an Output node
A template has no Output node. Add one from the node panel and connect it to the final node in the graph. Use the Output node values listed for your template in the Available templates section below. When scheduled, the workflow writes to processed_custom_data. It produces a separate table from the built-in version maintained by Navixy in processed_common_data.
Schedule the workflow
Click Schedule and set the execution frequency. Use the recommended schedule listed for your template in the Available templates section, or choose a different interval to match your reporting needs.
Available templates
The table below lists available templates with the values you need for the Output node and the recommended schedule. Each template links to its transformation page for algorithm details and customization guidance, and provides the YAML file for download.
Trips
Produces one row per vehicle trip from raw telematics data, with start and end times, distance, speed statistics, and zone detection. See the Trips page for the full output schema, algorithm description, and customization options.
When adding the Output node, use the following configuration:
Table name
trips
Time column
trip_start_time
Primary key
device_id, trip_start_time
Write mode
overwrite
Recommended schedule: 10 */8 * * * (UTC, every 8 hours), matching the update frequency of the built-in processed_common_data.trips transformation.
Sensor data aggregation
Produces time-bucketed aggregates of sensor readings, with decoding, fuel calibration, and human-readable enrichment applied. See the Sensor data aggregation page for the full output schema, algorithm description, and customization options.
The template ships pre-configured for 5-minute buckets, a common customization scenario for diagnostics dashboards. To change the bucket size, edit the interval literal in the Custom SQL node before scheduling. The interval value controls both the bucket size and the lookback window.
When adding the Output node, use the following configuration:
Table name
sensors_data_by_5min
Time column
hour_bucket
Primary key
device_id, hour_bucket, sensor_name, event_id
Partition by
DATE(hour_bucket)
Write mode
append
Recommended schedule: */5 * * * * (UTC, every 5 minutes), matching the 5-minute bucket size pre-configured in the template. If you change the interval, update the schedule to match so that each run reads exactly one bucket's worth of data.
Next steps
Common transformations: Learn what each transformation produces, how it is built, and how to customize the logic before importing a template.
Transformation Builder: Full reference for the visual workflow editor, node types, and execution options.
Workflow YAML reference: Specification for the YAML format used by these template files.
Last updated
Was this helpful?