Webforms

Webforms let you and your team enter data straight into a warehouse table through a simple spreadsheet-style form in Kleene, with no SQL or warehouse access needed. They're ideal for data that doesn't come from a source system, such as targets, budgets or mapping tables.

Schema

Webforms are stored in a schema in the main production instance of your warehouse called KLEENE_WEBFORMS. This is created automatically when you create a new table.

Each webform table includes four system columns that track every change:

_KWF_UUID — the row ID
_KWF_ACTIVE — whether the row is current
_KWF_UID — the user who saved it
_KWF_LAST_UPDATED — timestamp of last change

Note
Rows are never overwritten. Editing or deleting a row sets the old version to _KWF_ACTIVE = FALSE. Use WHERE _KWF_ACTIVE = TRUE in your transforms to get current data.

Create a webform

Go to Ingest > Webforms and click the + icon next to the Webforms heading. You have two options:

Existing table

Append information to a table already in the warehouse.

When you click Create new table:

On Snowflake: We copy the table and add the suffix _wf. The original table remains in the schema.
On Redshift: We rename the table with the suffix _wf.

You can also create new tables in this schema using the SQL Console, and they will appear in the list.

New table

Add a Table name and Table columns until you have the desired structure, then click Create new table. The table name can only include letters, numbers, and underscores — we add the suffix _wf automatically.

For each column, set:

Column name
Type — Number (whole numbers only) or Text (includes dates in YYYY-MM-DD format, e.g., 2026-09-30)
Nullable — Off by default, making the column mandatory. Mandatory columns are marked with a * in the webform and must be filled before saving.

Edit a webform (add data)

Once set up, users can click a webform's name to open it. From here they can:

Add a new line — Type into any empty row
Edit an existing line — Click a cell and type over the value
Delete a line — Use the ⋮ menu at the end of the row (select Restore row to undo before saving)
Filter lines — Use Filter field, Type, and Value, then click Apply

Visual indicators

Green — New lines
Yellow — Edited lines
Red — Deleted lines or invalid cells

Note: Any cell with an invalid value (empty mandatory column or text in a number column) is outlined in red and must be fixed before saving.

Click Save changes (top right) to write your changes to the warehouse.