Skip to main content
When the built-in actions don’t cover a transformation you need, drop down to code. The Python and SQL actions let you transform data on the Workflow canvas with AI assistance — describe what you want, and Corvic helps write the code, which you can then review, edit, and run.

​
When to use them

Use Python or SQL for custom logic that the dedicated actions (Augment, Join, Extract Tables, and so on) don’t express directly:
  • Reshaping, pivoting, or aggregating columns
  • Custom cleaning, parsing, or feature derivation
  • Filtering and reformatting before embedding
  • Calling external APIs from your API Secret Vault (Python)
On the canvas these appear as Python (execute_python) and SQL (execute_sql) actions. The agent’s reasoning chain refers to the same execute_python capability when it runs code to answer a question.

​
Python

The Python action runs an AI-assisted Python transform over the input table. Describe the transformation in plain language; Corvic drafts the code, and you can inspect and modify it before running. Python is also how agents call connected external APIs — credentials from the API Secret Vault are injected automatically, so your code references a connection by name rather than handling raw secrets.
📸 Screenshot to add: the Python action panel (prompt, generated code, run) — save as /images/action-python.png

​
SQL

The SQL action runs an AI-assisted SQL query over the input table. Use it for set-based transformations — joins, aggregations, window functions, and filtering — expressed in familiar SQL.
📸 Screenshot to add: the SQL action panel (prompt, generated query, run) — save as /images/action-sql.png

​
Where they run

Python and SQL actions can be applied to Corvic Table outputs, and can also run directly on Space outputs — letting you post-process embeddings and their associated data without leaving the canvas.

​
Usage

1

Add the action

Click the + next to a table or space node and choose Python or SQL.
2

Describe the transform

Write what you want in plain language. Corvic generates the code or query.
3

Review and edit

Inspect the generated code, adjust it as needed, and copy it if you want to reuse it.
4

Run

Execute the action to produce a new output you can use downstream.

Workflows

Build pipelines on the canvas.

API Secret Vault

Call external APIs from Python.

Action Reference

See all available canvas actions.