Data Utilities
Data Type Cross-Platform Reference
Enter a data type from one platform to see its equivalent on others. Covers numeric precision, timestamp variants, JSON/semi-structured types, and array types.
Calculations run locally in your browserTool
About this tool
Data Type Cross-Platform Reference
The Data Type Cross-Platform Reference maps data types across PostgreSQL, BigQuery, Snowflake, Redshift, MySQL, and Spark SQL, covering numeric, timestamp, JSON, and array types.
• Find the BigQuery equivalent of PostgreSQL JSONB before writing a migration script
• Check Snowflake TIMESTAMP_NTZ vs TIMESTAMP_TZ behavior when migrating from Redshift
• Look up the Spark SQL equivalent of a PostgreSQL NUMERIC(p,s) type for a lake migration
• Understand array type differences before writing a cross-platform dbt model
Next step
JSONPath Tester — Test JSONPath expressions against a JSON document with real-time results.
Open JSONPath Tester →
FAQ
What does this tool tell you?
The Data Type Cross-Platform Reference maps data types across PostgreSQL, BigQuery, Snowflake, Redshift, MySQL, and Spark SQL, covering numeric, timestamp, JSON, and array types.
What affects the result most?
Cross-platform type mapping: PostgreSQL VARCHAR(n) ↔ BigQuery STRING ↔ Snowflake VARCHAR ↔ Redshift VARCHAR. Numeric type precision: NUMERIC(p,s) precision and scale across all four platforms. Timestamp types: TIMESTAMP vs TIMESTAMPTZ vs TIMESTAMP_NTZ differences explained per platform.
How should I use the result?
Use this tool to orient quickly to the concepts, field names, or values you are about to look up in a full specification or vendor documentation. It summarizes the common cases; the authoritative source remains whichever standard or vendor doc defines the values themselves.