Data type mapping to BigQuery SQL - Prophecy Documentation

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 Type	Prophecy Data Type
`Array`	`array`
`Bigint`	`bigint`
`Binary`	`bytes`
`Date/Time`	`date/datetime`
`Decimal`	`decimal`
`Double`	`double`
`Integer`	`int`
`Nstring`	`string`
`Ntext`	`string`
`Real`	`float64`
`Small Integer`	`int`
`String`	`string`
`Struct`	`struct`
`Text`	`string`
`timestampWithTZ`	`timestamp`

To learn more about the Prophecy data types in SQL projects, see Supported data types.

Component mapping to BigQuery SQL

Function mapping to BigQuery SQL