> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Data type mapping to BigQuery SQL

> List of how Informatica data types map to Prophecy data types in BigQuery SQL

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](/data-analysis/gems/data-types).