Cast
Change column types.
Changes column types by mapping. The engine is handed a plain CAST, not a TRY_CAST, so a value that will not convert fails the query rather than becoming null — clean the column before this, not after it.
At a glance
Module type
Cast
Category
Primitives · Dataframe
Default tier
reactive
Runs on
reactive, durable
Starts a flow
no
Holds a body
no
Keeps state between runs
no
Available in
every application type
Parameters
mapping
Record<string, "string" | "number" | "boolean" | "datetime"> · required · defaults to {}
Column name to the type it should become; the engine gets a plain CAST, so a value that will not convert fails the query.
Inputs
on
event
no
Implicit on every module that does not itself start a flow: wire an event here to make this module the start of what that event runs.
data
dataframe
yes
The frame to work on.
Outputs
output
dataframe
dataframe, signal
The frame with the cast columns.
Last updated