Columns define the structure of your table and how data behaves. Each column has a name, a semantic data type, and a column type that controls whether it stores data, fetches it, computes it, or transforms it.
The six column types
Static columns (yellow)
Basic data storage. You enter or import data directly, like a regular spreadsheet cell.
Use for names, domains, emails, or any data you already have.
Processor columns (blue)
These run enrichment actions through connected integrations or providers. When you run enrichment, processor columns connect to external data sources to find information.
Use for finding work emails, job titles, company information, or anything you need to look up.
Data source columns (pink)
Pull data from an external connected source, like a CRM or database sync.
Use for keeping table data in sync with external systems.
Derived columns (green)
Compute values using formulas based on other columns in the same row.
Use for combining first and last name, calculating scores, conditional logic (IF/THEN), or extracting parts of data.
Waterfall columns (light blue)
Try multiple providers in sequence until data is found. If the first provider doesn't return a result, the next one tries automatically.
Use for maximizing data coverage on fields like email or phone number.
Output columns (purple)
Hold data received from webhooks. When external systems send data to TexAu via a webhook, it lands in these columns.
Use for receiving data from external systems in real time.
Column color coding
Each column type has a distinct color in the table header, so you can see your table structure at a glance:
This table scrolls sideways on small screens.
| Type | Color |
|---|---|
| Static | Yellow |
| Processor | Blue |
| Data Source | Pink |
| Derived | Green |
| Waterfall | Light Blue |
| Output | Purple |
Adding a column
- Click the + icon at the end of your column headers.
- Choose the column type (Static, Processor, Data Source, Derived, Waterfall, or Output).
- Name your column clearly (for example, "Work Email" or "Company Size").
- Select the semantic data type (Email, Phone, Company Name, etc.).
- Configure type-specific settings:
- Processor: choose the data provider and map input columns.
- Derived: enter your formula.
- Waterfall: select providers and set the priority order.
- Click Save.
Managing columns
Renaming
Click the column header, select Edit, and change the name.
Hiding and showing
You can hide columns you don't need visible without deleting them. Hidden columns keep their data. Use the Show Hidden Columns button in the toolbar to bring them back.
Deleting
Click the column header, select Delete, and confirm. Deleting a column removes all its data permanently.
Tip: If you're not sure whether you need a column, hide it instead of deleting it.
Column limits
All plans support up to 100 columns per table. Most tables use 15-30. If you're approaching the limit, consider splitting into multiple tables with a shared identifier like email or company domain.
Next steps
- Semantic data types —all 32+ data types explained
- Working with rows —add and manage records
- Running enrichments —run enrichments on your data