Data types conversion chart

This is how the data types in your logical data model will change if you generate physical model from it.

Legend:

  • %n - length
  • %s - number of digits
  • %p - number of decimals
Type in logical modelParametersMySQLPostgresMicrosoft SQL ServerOracleIBM DB2HSQL DBSQLiteAmazon RedshiftGoogle BigQuery
Numeric
BytetinyintsmallinttinyintsmallintsmallinttinyinttinyintsmallintINT64
IntegerintintintintegerintegerintintegerintINT64
LongIntegerbigintbigintbigintintegerbigintbigintbigintbigintINT64
Serial%nserialserialintnumber(%n)integerintegerintegerintINT64
Decimal%s,%pdecimal(%s,%p)decimal(%s,%p)decimal(%s,%p)number(%s,%p)decimal(%s,%p)decimal(%s,%p)decimal(%s,%p)decimal(%s,%p)NUMERIC
Number%s,%pnumeric(%s,%p)numeric(%s,%p)numeric(%s,%p)number(%s,%p)decimal(%s,%p)decimal(%s,%p)decimal(%s,%p)numeric(%s,%p)NUMERIC
Money%s,%pdecimal(%s,%p)moneymoneynumber(%s,%p)decimal(%s,%p)decimal(%s,%p)decimal(%s,%p)decimal(%s,%p)NUMERIC
ShortFloatfloatrealrealfloatrealrealrealrealFLOAT64
Float%nfloat(%n)float(%n)float(%n)float(%n)doublefloatfloatfloatFLOAT64
LongFloatdoubledouble precisionfloatfloatdoubledoubledoubledouble precisionFLOAT64
String
Char%nchar(%n)char(%n)char(%n)char(%n)char(%n)char(%n)character(%n)char(%n)STRING
Varchar%nvarchar(%n)varchar(%n)varchar(%n)varchar2(%n)varchar(%n)varchar(%n)varchar(%n)varchar(%n)STRING
NChar%nnchar(%n)char(%n)nchar(%n)nchar(%n)char(%n)char(%n)character(%n)char(%n)STRING
NVarchar%nnvarchar(%n)varchar(%n)nvarchar(%n)nvarchar2(%n)varchar(%n)varchar(%n)varchar(%n)varchar(%n)STRING
Date and Time
DatedatedatedatedatedatedatedatedateDATE
Timetimetimetimedatetimetime--TIME
DateTimedatetimetimestampdatetimedatedatetimestampdatetimetimestampDATETIME
Timestamptimestamptimestampdatetime2timestamptimestamptimestampdatetimetimestampTIMESTAMP
Large and others
Text%nlongtexttexttextclobclob(%n)clob(%n)clob-STRING
Binary%nlongblobbyteavarbinary(%n)blobblob(%n)blob(%n)blob-BYTES
BooleanbooleanbooleanbitsmallintbooleanbooleanbooleanbooleanBOOL