Skip to main content
The following tables list all the Informatica data types that Prophecy supports and the corresponding Prophecy data type it maps to in BigQuery SQL:
Informatica Data TypeProphecy Data Type
Arrayarray
Bigintbigint
Binarybytes
Date/Timedate/datetime
Decimaldecimal
Doubledouble
Integerint
Nstringstring
Ntextstring
Realfloat64
Small Integerint
Stringstring
Structstruct
Textstring
timestampWithTZtimestamp
To learn more about the Prophecy data types in SQL projects, see Supported data types.