1. Home
  2. Previous Releases
  3. Latest Release
  4. Guides
  5. Concepts
  6. Tools
  7. References
    1. Apache Spark
    2. Built-in Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
    6. Data Studio
      1. Enabling the Data Studio
      2. Aggregation Recipe
      3. Change Type Recipe
      4. Data Quality Recipe
      5. Filter Recipe
      6. Formula Recipe
      7. Fuzzy Join Recipe
      8. Join Recipe
      9. LLM Recipe
      10. Python Recipe
      11. Rename Recipe
      12. Sample Recipe
      13. Save MV Recipee
      14. Select Recipe
      15. Sort Recipe
      16. Split Recipe
      17. SQL Recipe
      18. Union Recipe
      19. Unpivot Recipe
    7. Public API
    8. Security
    9. SQL Interface
    10. Visualizations
    11. Other
  8. Integrations
  9. Data applications
  10. Releases
  11. Incorta Premium

References → Change Type Recipe

This recipe is designated to transform the data type of an existing column to a new data type. Generally, best practices would dictate that the data type is correctly configured in the schema, but there are scenarios where data types need to be updated during transformation.

Configuration

ConfigurationDescription
Recipe NameA freeform name of how a user would like to name a recipe
InputSelect a previously constructed recipe to process
Change Column TypeSelect a column to be transformed into a new type. Next, select the type to transform it into.

Data Type Options

TypeDescription
StringIdeal for storing short to medium variable-length character data.
TextIdeal for storing long variable-length character data. If you choose to output this type to an MV, downstream reporting will not allow this as a grouping dimension.
IntegerA 32-bit integer ranging from -2,147,483,648 to 2,147,483,647
LongA 64-bit integer ranging from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
DoubleA floating-point number handles decimal points for optimal precision.
DateConvert to a date represented as YYYY-MM-DD. Note that the string value must be in this format before conversion.
TimestampConvert to a datetime represented as YYYY-MM-DD HH:MM:SS. Note that the string value must be in this format before conversion.
BooleanConvert a flag field (0,1) to Boolean true/false data type.

Incorta dataflows will always try to enforce datatypes in conversion. If the resulting data turns to NULL, the value is incompatible with the target data type.

For example:

  • Converting the word “Incorta” to an Integer will result in a NULL value.
  • Converting the string “Sept-13,2024” to Date will result in a NULL value.
Note

If the schema in the dataflow has a changed datatype, go to ‘...’ and select the Refresh Schemas option.