Skip to main content
MantrixFlow home page
Documentation
Guides
API reference
Changelog
Talk to us
Get started
Get started
Search...
Navigation
Transformations
Cast Types
Search...
⌘K
Introduction
Welcome
Getting started
Introduction
Quick Start
Core Concepts
FAQ
Connections
Connections Overview
Sources
Destinations
Pipelines
Pipelines Overview
Creating a Pipeline
Sync Modes
Column Mapping
Transformation Rules
Schedule and Automation
Run History
Sync reference
Full Sync
Incremental Sync
CDC Overview
CDC Setup for PostgreSQL
CDC Setup for MySQL
CDC Setup for SQL Server
Sync State
Reset Sync State
Transformations
Rename Columns
Cast Types
Filter Rows
Add Column
Fill Nulls
Custom Rules
Platform
Organisation Setup
Team Members
Billing
Security and Encryption
Data Privacy
On this page
When to Use
Example
Supported Types
Transformations
Cast Types
Convert column data types during sync.
The cast transformation changes the data type of a column. Use it when the inferred type is wrong or the destination expects a specific type.
When to Use
A string column contains numbers and should be numeric.
A date is stored as string and should be a date type.
The destination requires a specific type (e.g. boolean, integer).
Example
Cast price from string to float. Values like “19.99” become 19.99.
Supported Types
Common types include: string, integer, float, boolean, date, datetime. The exact set depends on the pipeline configuration.
Rename Columns
Previous
Filter Rows
Next
⌘I