Skip to content

Convert Type

Convert the data types of the input flow. Generates a select clause, casting column types.

If possible, it's better to change the source data so that it already has the correct types. However, sometimes it's necessary to convert the types explicitly.

Snowflake types include: VARCHAR, NUMBER, FLOAT, BOOLEAN, DATE, TIMESTAMP, TIME, and VARIANT. The use of these data types is detailed in the Snowflake documentation.

Delta Lake on Databricks types include: INTEGER, NUMBER, FLOAT, TEXT, TIMESTAMP, DATE, BOOLEAN, and BINARY. The use of these data types is detailed in the Databricks documentation.

Note

  • When appropriate, values are first rounded to the requested decimal places before being cast to the requested size.
  • Users may experience casting errors if using binary values.
  • Although syntax is checked at validation time, runtime errors may occur during type conversion if the input data cannot fit into the requested target type.

Properties

Name = string

A human-readable name for the component.


Conversions = column editor

Enter the following details for each table column:

  • Column: The name of the column to convert.
  • Type: Choose one of the tabs below for documentation applicable to that data type.
  • Size: For Text types, this is the maximum length. This is a limit on the number of bytes, not characters. For Numeric types, this is the total number of digits allowed, whether before or after the decimal point.
  • Precision: The precision of the data in the column. Will be 0 (zero) for non-applicable types.
  • Varchar: This type is suitable for numbers and letters. A varchar or Variable Character Field is a set of character data of indeterminate length. For more information read, Snowflake VARCHAR types.
  • Number: This type is suitable for numeric types, with or without decimals. For more information, read Snowflake Numeric Data types.
  • Float: These types of values are approximate numeric values with fractional components. For more information, read Snowflake Float type .
  • Boolean: This type is suitable for data that is either "true" or "false", or "1" or "0", respectively. For more information, read Snowflake Logical Operators.
  • Date: This type is suitable for dates without times. For more information, read Snowflake Date/Time types.
  • Timestamp: This type is a timestamp left unformatted (exists as Unix/Epoch Time). For more information, read Snowflake Date and Time Data types.
  • Time: This type is suitable for time, independent of a specific date and timezone. For more information, read Snowflake Time type.
  • Variant: Variant is a tagged universal type that can hold up to 16 MB of any data type supported by Snowflake. For more information, read Snowflake Variant type.
  • Integer: This type is suitable for whole-numbers (no decimals). For more information, read Databricks INT type.
  • Number: This is suitable for numeric types, with or without decimals. For more information, read Databricks Numeric Data types.
  • Float: These types of values are approximate numeric values with fractional components. For more information, read Databricks Float type.
  • Text: Represents character string values. For more information, read Databricks String type.
  • Boolean: This type is suitable for data that is either "true" or "false", or "1" or "0", respectively. For more information, read Databricks Boolean type.
  • Binary: This data type represents byte sequence values. For more information, read Databricks Binary type.
  • Date: This type is suitable for dates without times. For more information, read Databricks Date type.
  • Timestamp: This type is a timestamp left unformatted (exists as Unix/Epoch Time). For more information, read Databricks timestamp type.

Snowflake Databricks Amazon Redshift (preview)