Convert Type
Convert column data type
What It Does
Convert Type changes a column's data type. Convert text to numbers, dates to text, or parse date strings with custom formats.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Convert Type". It's in the Transform group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select | Yes | The column to convert |
Target type | Select | Yes | VARCHAR, INTEGER, BIGINT, DOUBLE, BOOLEAN, DATE, TIMESTAMP |
Source format | Text | No | Date format string for parsing (e.g., %Y-%m-%d) |
SQL generated under the hood
SELECT *, TRY_CAST(price AS DOUBLE) AS price FROM dataRelated Operations
- Update Values - Update column values with expression
- Find & Replace - Search and replace values in a column
- Text Transform - Transform text: uppercase, lowercase, trim