---
title: "Strata block reference by palette | Oplema"
description: "Browse Strata blocks by palette, from IO and Prep to Combine, Transform, Parse and Developer, with settings, inputs and outputs, plus every function."
url: "https://oplema.com/docs/strata"
updated: "2026-11-04"
---

# Strata documentation

This is the block and function reference for Strata, Oplema's browser app for data prep. Choose a palette by task, then open a block to see its inputs, outputs and settings.

## Find the next step in your flow

New to Strata? Read [What is Strata?](https://oplema.com/docs/strata/what-is-strata) for how flows, the canvas and the script fit together. To learn it hands-on, take [Build a report from a CSV export](https://oplema.com/learn/export-to-report), the first Strata course.

To work through the reference from the beginning, open the [IO palette](https://oplema.com/docs/strata/io), then [Input](https://oplema.com/docs/strata/io/input). Input brings a table into the flow. Then open the palette for your next step.

## Choose a palette by task

- Load or create tables, write results out and link tables and values to Vista.
- Keep the rows and columns you need, clean values and add calculated columns.
- Join related tables or append rows from tables you want to bring together.
- Group rows into summaries, pivot values into columns or change the structure of a table.
- Turn text into real dates and numbers, unpack JSON, extract patterns and split lists.
- Run your own Python or R when no other block does what you need.
- Explain flows and label sections with notes on the canvas.

## Choose by the result you need

Each palette groups blocks by task, and each block does one thing. To combine two tables, for example, open Combine. Use Join to match related rows, or Union to stack the rows of both tables.

Each block page says when to use the block, then covers its inputs, outputs and settings. Palettes can be used in any order.

## Find functions for calculations and conditions

Use the [Formula function reference](https://oplema.com/docs/strata/functions) when you need an expression inside a block. Formula calculations and Filter custom conditions use DuckDB SQL.

For a calculated column, start with the Formula block's settings, then look up the functions your expression needs. A text function might change letter case; a date function might extract part of a date.

## Strata reference FAQs

**Which Strata block should I start with?**

Start with Input in the IO palette to bring a table into your flow. Then choose blocks for the changes your data needs, such as Filter to keep selected rows or Summarize to calculate grouped totals.

**What is a palette in Strata?**

A palette is a group of Strata blocks for one kind of task, such as cleaning values or combining tables. Each palette page lists its blocks and links to their reference pages.

**What is the difference between a block and a function?**

A block is a step in a Strata flow. A function is used inside an expression, such as a calculation in Formula or a condition in Filter's Custom expression mode. The function reference covers the available DuckDB SQL functions.

### Start with a table. Build from there.

Explore Input, or open Strata with your own data.

[Explore Input](https://oplema.com/docs/strata/io/input) [Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata)
