Transforms

Transforms let you materialize repeatable queries into new datasets.

You can:

• Run transforms on-demand
• Schedule transforms with cron
• Use transform outputs as datasets in Explore / Conversations

Where to find Transforms

Navigate to Data → Transforms in the sidebar.

Create a Transform (YAML)

On the Transforms page:

• Click Create to create a single transform via YAML
• Click Apply YAML to apply multiple transforms at once

Save and Transform from Conversations

In a Conversation, the composer has execution modes Ask / Generate / Raw. Click Save to create a transform from the current mode:

• Ask: Saves your natural-language prompt as a fino transform.
• Generate: Saves the generated SQL/QueryDSL from the assistant response.
• Raw: Saves the exact SQL/QueryDSL you authored.

Click Transform to save + execute the transform, then switch the current conversation’s dataset selection to the newly materialized dataset.