Target data type support & mapping for YugabyteDB sources
See Data Types for a list of supported data type aliases (such as decimal and varchar).
If your screen is not wide enough to display the whole table, click in a cell and drag left to view the right-hand columns.
Yugabyte Data Type | Azure Synapse | BigQuery | Databricks | Db2 for z/OS | MariaDB | Microsoft Fabric | MySQL | Oracle | PostgreSQL | Snowflake | Spanner | SQL Server | Yellowbrick |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BIGSERIAL | bigint | int64 | bigint | bigint | bigint | bigint | bigint | int | bigserial | integer | INT64 | bigint | bigint |
BIT | BIT | bytes(p) | binary | binary(255) | bit(p) | BIT | bit(p) | BLOB | bit | BINARY | STRING(p) | BIT | character varying(p) |
BIT(p) | varchar(p), if 1 <= (p) <= 8000 varchar(8000), if (p) > 8000* | bytes, if (p) > 9223372036854775807* bytes(p), if (p) <= 9223372036854775807 | binary | binary(255), if (p) <= 127 | binary(255), if (p) > 64 bit(p), if (p) <= 64 | varchar(p), if 1 <= (p) <= 8000 varchar(8000), if (p) > 8000* | binary(255), if (p) > 64 bit(p), if (p) <= 64 | BLOB | bit varying(p), if 1 <= (p) <= 2147483647 | BINARY, if (p) <= 8388608 BINARY, if (p) > 8388608* | STRING(p), if (p) <= 2621440 | varchar(max), if (p) > 8000* varchar(p), if 1 <= (p) <= 8000 | character varying(p), if (p) <= 64000 |
BOOL | BIT | boolean | boolean | Not supported | bool | BIT | bool | CHAR(5) | boolean | BOOLEAN | BOOL | BIT | boolean |
BOX | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
BPCHAR | character(p) | string | string | character(p) | character(p) | varchar(p) | character(p) | character(p) | bpchar(p) | character(p) | STRING(p) | character(p) | bpchar(p) |
BPCHAR(p) | character(p), if (p) <= 8000 varchar(8000), if (p) > 8000* | string | string | character(p), if (p) <= 255 clob(p), if 255 <= (p) <= 2147483647 | character(p), if (p) <= 255 longtext, if 255 <= (p) <= 2147483647 | varchar(p), if (p) <= 8000 varchar(8000), if (p) > 8000* | character(p), if (p) <= 255 longtext, if 255 <= (p) <= 2147483647 | clob, if (p) > 2000* character(p), if (p) <= 2000 | bpchar(p), if (p) <= 10485760 bpchar, if (p) > 10485760* | character(16777216), if (p) > 16777216* character(p), if (p) <= 16777216 | STRING(p), if (p) <= 2621440 | character(p), if (p) <= 8000 varchar(max), if (p) > 8000* | bpchar(p), if (p) <= 64000 bpchar, if (p) > 64000* |
BYTEA | varbinary(8000) | bytes(p) | binary | blob(p) | longblob | varbinary(8000) | longblob | BLOB | bytea | BINARY | BYTES(MAX) | varbinary(max) | Not supported |
CIDR | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | cidr | varchar(150) | STRING(150) | varchar(150) | character varying(150) |
CIRCLE | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | circle | varchar(150) | STRING(150) | varchar(150) | character varying(150) |
DATE | date | date | date | date | date | date | date | date | date | date | DATE | date | date |
DATERANGE | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
FLOAT4 | float(p) | float64 | float | real | float(p) | float(p) | float(p) | float(p) | real | float | FLOAT64 | float(p) | real |
FLOAT4 - CDDL | float(p) | float64 | float | real | real | float(p) | float(p) | float(p) | real | float | FLOAT64 | float(p) | real |
FLOAT8 | float(p) | float64 | float | real | float(p) | float(p) | float(p) | float(p) | double precision | float | FLOAT64 | float(p) | real |
FLOAT8 - CDDL | float(p) | float64 | float | real | real | float(p) | float(p) | float(p) | double precision | float | FLOAT64 | float(p) | real |
INET | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | inet | varchar(150) | STRING(150) | varchar(150) | character varying(150) |
INT2 | smallint | int64 | bigint | smallint | smallint | smallint | smallint | int | smallint | integer | INT64 | smallint | smallint |
INT4 | integer | int64 | bigint | integer | integer | int | integer | int | integer | integer | INT64 | integer | integer |
INT4RANGE | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
INT8 | bigint | int64 | bigint | bigint | bigint | bigint | bigint | int | bigint | integer | INT64 | bigint | bigint |
INT8RANGE | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
INTERVAL | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | interval | varchar(150) | STRING(150) | varchar(150) | character varying(150) |
INTERVAL(p) | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | interval, if (p) <= 49, if (s) <= 6 | varchar(150) | STRING(150) | varchar(150) | character varying(150) |
JSON | varchar(8000) | string | string | clob | json | varchar(8000) | json | clob | json | VARIANT | STRING(MAX) | varchar(max) | character varying |
JSONB | varchar(8000) | string | string | clob | json | varchar(8000) | json | clob | jsonb | VARIANT | STRING(MAX) | varchar(max) | character varying |
LINE | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | line | varchar(150) | STRING(150) | varchar(150) | character varying(150) |
LSEG | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | lseg | varchar(150) | STRING(150) | varchar(150) | character varying(150) |
MACADDR | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | macaddr | varchar(150) | STRING(150) | varchar(150) | macaddr |
MONEY | numeric(38) | string | string | varchar(150) | varchar(150) | decimal(38,4) | varchar(150) | VARCHAR2(150) | numeric | varchar(150) | STRING(150) | numeric(38) | character varying(150) |
NUMERIC | numeric(38) | bignumeric | decimal(38) | numeric | decimal(65) | decimal(38) | decimal(65) | number | numeric | numeric | NUMERIC | numeric(38) | decimal |
NUMERIC(p,0) | numeric(p,s), if (p) <= 38, if (s) <= 38 | numeric, if (p) <= 29, if (s) <= 9 | decimal(p,s), if (p) <= 38, if (s) <= 37 | numeric(p,s), if (p) <= 31, if (s) <= 30 | decimal(p,s), if (p) <= 65, if (s) <= 30 | decimal(p,s), if (p) <= 38, if (s) <= 38 | decimal(p,s), if (p) <= 65, if (s) <= 30 | number(p,s), if (p) <= 38, if (s) <= 127 | numeric(p,s), if (p) <= 1000, if (s) <= 1000 | numeric(p,s), if (p) <= 38, if (s) <= 37 | NUMERIC, if (p) <= 38, if (s) <= 9 | numeric(p,s), if (p) <= 38, if (s) <= 38 | decimal(p,s), if (p) <= 38, if (s) <= 38 |
NUMERIC(p,s) | varchar(8000), if (p,s) > 38, if (s) > 38* numeric(p,s), if (p) <= 38, if (s) <= 38 | string, if (p,s) > 39, if (s) > 38* numeric, if (p) <= 29, if (s) <= 9 bignumeric, if 29 <= (p) <= 39, if 9 <= (s) <= 38 | string, if (p,s) > 38, if (s) > 37* decimal(p,s), if (p) <= 38, if (s) <= 37 | numeric(p,s), if (p) <= 31, if (s) <= 30 numeric, if (p,s) > 31, if (s) > 30* | decimal(p,s), if (p) <= 65, if (s) <= 30 TEXT, if (p,s) > 65, if (s) > 30* | varchar(8000), if (p,s) > 38, if (s) > 38* decimal(p,s), if (p) <= 38, if (s) <= 38 | decimal(p,s), if (p) <= 65, if (s) <= 30 TEXT, if (p,s) > 65, if (s) > 30* | number, if (p,s) > 38, if (s) > 127* number(p,s), if (p) <= 38, if (s) <= 127 | double precision, if (s) > 1000 double precision, if (p,s) > 1000 numeric(p,s), if (p) <= 1000, if (s) <= 1000 | numeric(p,s), if (p) <= 38, if (s) <= 37 VARCHAR, if (p,s) > 38, if (s) > 37* | NUMERIC, if (p) <= 38, if (s) <= 9 STRING(MAX), if (p,s) > 308, if (s) > 15* | varchar(8000), if (p,s) > 38, if (s) > 38* numeric(p,s), if (p) <= 38, if (s) <= 38 | character varying, if (p,s) > 38, if (s) > 38* decimal(p,s), if (p) <= 38, if (s) <= 38 |
NUMRANGE | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
PATH | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | path | varchar(150) | STRING(150) | varchar(150) | character varying(150) |
POINT | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
POLYGON | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
SERIAL | integer | int64 | bigint | integer | integer | int | integer | int | serial | integer | INT64 | integer | integer |
SMALLSERIAL | smallint | int64 | bigint | smallint | smallint | smallint | smallint | int | smallserial | integer | INT64 | smallint | smallint |
TEXT | varchar(8000) | string | string | clob(p) | LONGTEXT | varchar(8000) | LONGTEXT | clob | text | VARCHAR | STRING(MAX) | varchar(max) | character varying |
TIME | time | time | string | time | time(s) | time(6) | time(s) | VARCHAR2(150) | time(s) | time | STRING(150) | time | time |
TIME - CDDL | time | time | string | time | time | time(6) | time(s) | VARCHAR2(150) | time(s) | time | STRING(150) | time | time |
TIME(p) | time | string, if (s) > 6* time, if (s) <= 6 | string | time | varchar(150), if (s) > 6* time(s), if (s) <= 6 | time(6) | varchar(150), if (s) > 6* time(s), if (s) <= 6 | VARCHAR2(150) | time(s), if (p) <= 15, if (s) <= 6 time, if (p) > 15* time, if (s) > 6* | time | STRING(150) | time | time |
TIMESTAMP | datetime2 | timestamp | timestamp | timestamp | datetime(s) | datetime2(6) | datetime(s) | timestamp(s) | timestamp(s) without time zone | timestamp | TIMESTAMP | datetime2 | timestamp |
TIMESTAMP - CDDL | datetime2 | timestamp | timestamp | timestamp | timestamp | datetime2(6) | datetime(s) | timestamp(s) | timestamp(s) without time zone | timestamp | TIMESTAMP | datetime2 | timestamp |
TIMESTAMP(p) | datetime2 | timestamp, if (s) <= 6 timestamp, if (s) > 6* | timestamp | timestamp | varchar(34), if (s) > 6* datetime(s), if (s) <= 6 | datetime2(6) | varchar(34), if (s) > 6* datetime(s), if (s) <= 6 | timestamp(s), if (s) <= 9 timestamp, if (s) > 9* | timestamp without time zone, if (s) > 6* timestamp without time zone, if 29 <= (p) <= 29* timestamp(s) without time zone, if (p) <= 29, if (s) <= 6 | timestamp | TIMESTAMP | datetime2 | timestamp |
TIMESTAMPTZ | datetimeoffset | timestamp | timestamp | timestamp with time zone | timestamp | datetime2(6) | timestamp | timestamp with time zone | timestamp(s) with time zone | timestamp with time zone | TIMESTAMP | datetimeoffset | timestamptz |
TIMESTAMPTZ(p) | datetimeoffset | timestamp, if (s) <= 6 timestamp, if (s) > 6* | timestamp | timestamp with time zone | timestamp | datetime2(6) | timestamp | timestamp with time zone | timestamp(s) with time zone, if (p) <= 35, if (s) <= 6 timestamp with time zone, if (s) > 6* timestamp with time zone, if 35 <= (p) <= 35* | timestamp with time zone | TIMESTAMP | datetimeoffset | timestamptz |
TIMETZ | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | time(s) with time zone | VARCHAR(150) | STRING(150) | varchar(150) | character varying(150) |
TIMETZ(p) | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | time(s) with time zone, if (p) <= 21, if (s) <= 6 | VARCHAR(150) | STRING(150) | varchar(150) | character varying(150) |
TSQUERY | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
TSRANGE | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
TSTZRANGE | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
TSVECTOR | varchar(8000) | string | string | varchar(250) | text | varchar(8000) | text | VARCHAR2(200) | character varying | VARCHAR | STRING(MAX) | varchar(8000) | character varying |
TXID_SNAPSHOT | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | txid_snapshot | varchar(150) | STRING(150) | varchar(150) | character varying(150) |
UUID | varchar(150) | string | string | varchar(150) | varchar(150) | varchar(150) | varchar(150) | VARCHAR2(150) | uuid | varchar(150) | STRING(150) | varchar(150) | Not supported |
VARBIT | varbinary(8000) | bytes(p) | binary | blob | binary(255) | varbinary(8000) | binary(255) | BLOB | varbit | BINARY | BYTES(MAX) | varbinary(max) | Not supported |
VARBIT(p) | varbinary(8000), if (p) > 8000* varbinary(p), if (p) <= 8000 | bytes, if (p) > 9223372036854775807* bytes(p), if (p) <= 9223372036854775807 | binary | blob, if (p) > 1011* varbinary(4046), if (p) <= 1011 | bit(64), if (p) <= 64 binary(255), if (p) > 64 | varbinary(8000), if (p) > 8000* varbinary(p), if (p) <= 8000 | bit(64), if (p) <= 64 binary(255), if (p) > 64 | BLOB | varbit, if (p) > 83886080* varbit(p), if (p) <= 83886080 | BINARY, if (p) <= 8388608 BINARY, if (p) > 8388608* | BYTES(MAX), if (p) > 10485760* BYTES(p), if (p) <= 10485760 | varbinary(p), if (p) <= 8000 varbinary(max), if (p) > 8000* | character varying(p), if (p) <= 64000 |
VARCHAR | varchar(p) varchar(8000) | string | string | clob(p) varchar(p) | longtext varchar(p) | varchar(p) varchar(8000) | longtext varchar(p) | clob VARCHAR2(p) | character varying(p) | VARCHAR(p) | STRING(p) STRING(MAX) | varchar(p) varchar(max) | character varying(p) |
VARCHAR(p) | varchar(p), if (p) <= 8000 varchar(8000), if (p) > 8000* | string | string | varchar(p), if (p) <= 4045 clob(p), if 4045 <= (p) <= 2147483647 | varchar(p), if (p) <= 65535 longtext, if 65535 <= (p) <= 2147483647* | varchar(p), if (p) <= 8000 varchar(8000), if (p) > 8000* | varchar(p), if (p) <= 65535 longtext, if 65535 <= (p) <= 2147483647* | clob, if (p) > 4000* VARCHAR2(p), if (p) <= 4000 | character varying(p), if (p) <= 10485760 character varying, if (p) > 10485760* | VARCHAR, if (p) > 16777216* VARCHAR(p), if (p) <= 16777216 | STRING(MAX), if (p) > 2621440 STRING(p), if (p) <= 2621440 | varchar(max), if (p) > 8000* varchar(p), if (p) <= 8000 | character varying, if (p) > 64000* character varying(p), if (p) <= 64000 |
XML | varchar(8000) | string | string | xml | LONGTEXT | varchar(8000) | LONGTEXT | xmltype | xml | varchar | STRING(MAX) | xml | character varying |
*When using the schema conversion utility, these mappings appear in converted_tables_with_striim_intelligence.sql.