Snowflake Connector Guide

Snowflake Connector Guide

Data Type Reference Overview

Data Type Reference Overview

Data Integration uses the following data types in Snowflake mappings and mapping tasks:
  • Snowflake native data types appear in the source and target transformations when you choose to edit metadata for the fields.
  • Transformation data types. Set of data types that appear in the transformations. These are internal data types based on ANSI SQL-92 generic data types, which the Secure Agent uses to move data across platforms. They appear in all transformations in a mapping.
When the Secure Agent reads source data, it converts the native data types to the comparable transformation data types before transforming the data. When the Secure Agent writes to a target, it converts the transformation data types to the comparable native data types.

Updated March 07, 2019


Explore Informatica Network