Database Ingestion and Replication > Database Ingestion and Replication > Default data-type mappings
  

Default data-type mappings

This reference provides default data-type mappings for relational sources and Amazon Redshift, Databricks, Google BigQuery, Microsoft Azure Synapse Analytics, Microsoft SQL Server, Oracle, PostgreSQL, and Snowflake targets. When Database Ingestion and Replication generates the target tables, it uses these mappings.
When you configure a target, you can optionally define custom data-type mapping rules to override the default mappings of source data types to target data tables for the job. For more information, see the target-specific topics accessed from Task Details: Configure how to replicate data to the target.
If a source data type is not listed, Database Ingestion and Replication either cannot extract data from the source columns with this data type or cannot apply the extracted data to any appropriate target data type.

Db2 for i Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for i source and an Amazon Redshift target:
Db2 for i Source Data Type
Amazon Redshift Target Data Type
bigint
bigint
binary(size), 1 <= size <= 32766
binary varying(size), 1 <= size <= 32766
char(size) for bit data, 1 <= size <= 32766
binary varying(size), 1 <= size <= 32766
char(size), 1 <= size <= 1024
character(size), 4 <= size <= 4096
char(size), 1025 <= size <= 32766
character varying(size), 4100 <= size <= 65535
date
date
decfloat(precision), 16 <= p <= 34
character varying(255)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
decimal(p,s), 38 <= p <= 63, 0 <= s <= 62
character varying(size), 40 <= size <= 65
float
double precision
integer
integer
long varbinary
binary varying(1024000)
long varchar
character varying(65535)
long varchar for bit data
binary varying(1024000)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 38 <= p <= 63, 0 <= s <= 62
character varying(size), 40 <= size <= 65
real
real
rowid
binary varying(40)
smallint
smallint
time
time without time zone
timestamp(precision), 0 <= p <= 6
timestamp without time zone
timestamp(precision), 7 <= p <= 12
character varying(size), 27 <= size <= 32
varbinary(size), 1 <= size <= 32740
binary varying(size), 1 <= size <= 32740
varchar(size) for bit data, 1 <= size <= 32740
binary varying(size), 1 <= size <= 32740
varchar(size), 1 <= size <= 32740
character varying(size), 4 <= size <= 65535
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for i data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for i Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for i source and a Databricks target:
Db2 for i Source Data Type
Databricks Target Data Type
bigint
long
binary(size), 1 <= size <= 32766
binary
char(size) for bit data, 1 <= size <= 32766
binary
char(size), 1 <= size <= 32766
string
date
string
decfloat(precision), 16 <= p <= 34
string
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 39 <= p <= 63, 0 <= s <= 62
string
float
double
integer
integer
long varbinary
binary
long varchar
string
long varchar for bit data
binary
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 39 <= p <= 63, 0 <= s <= 62
string
real
float
rowid
binary
smallint
integer
time
string
timestamp(precision), 0 <= p <= 6
timestamp
timestamp(precision), 7 <= p <= 12
string
varbinary(size), 1 <= s <= 32740
binary
varchar(size) for bit data, 1 <= size <= 32740
binary
varchar(size), 1 <= size <= 32740
string
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for i data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for i Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for i source and a Google BigQuery target:
Db2 for i Source Data Type
Google BigQuery Target Data Type
bigint
int64
binary(size), 1 <= size <= 32766
bytes
char(size) for bit data, 1 <= size <= 32766
bytes
char(size), 1 <= size <= 32766
string
date
date
decfloat(precision), 16 <= p <= 34
string
decimal(1,1)
numeric
decimal(10,10)
bignumeric
decimal(11,s), 10 <= s <= 11
bignumeric
decimal(12,s), 10 <= s <= 12
bignumeric
decimal(13,s), 10 <= s <= 13
bignumeric
decimal(14,s), 10 <= s <= 14
bignumeric
decimal(15,s), 10 <= s <= 15
bignumeric
decimal(16,s), 10 <= s <= 16
bignumeric
decimal(17,s), 10 <= s <= 17
bignumeric
decimal(18,s), 10 <= s <= 18
bignumeric
decimal(19,s), 10 <= s <= 19
bignumeric
decimal(2,s), 1 <= s <= 2
numeric
decimal(20,s), 10 <= s <= 20
bignumeric
decimal(21,s), 10 <= s <= 21
bignumeric
decimal(22,s), 10 <= s <= 22
bignumeric
decimal(23,s), 10 <= s <= 23
bignumeric
decimal(24,s), 10 <= s <= 24
bignumeric
decimal(25,s), 10 <= s <= 25
bignumeric
decimal(26,s), 10 <= s <= 26
bignumeric
decimal(27,s), 10 <= s <= 27
bignumeric
decimal(28,s), 10 <= s <= 28
bignumeric
decimal(3,s), 1 <= s <= 3
numeric
decimal(4,s), 1 <= s <= 4
numeric
decimal(5,s), 1 <= s <= 5
numeric
decimal(6,s), 1 <= s <= 6
numeric
decimal(7,s), 1 <= s <= 7
numeric
decimal(8,s), 1 <= s <= 8
numeric
decimal(p,0), 1 <= p <= 18
int64
decimal(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
decimal(p,s), 29 <= p <= 48, 0 <= s <= 29
bignumeric
decimal(p,s), 30 <= p <= 49, 0 <= s <= 30
bignumeric
decimal(p,s), 31 <= p <= 50, 0 <= s <= 31
bignumeric
decimal(p,s), 32 <= p <= 51, 0 <= s <= 32
bignumeric
decimal(p,s), 33 <= p <= 52, 0 <= s <= 33
bignumeric
decimal(p,s), 34 <= p <= 53, 0 <= s <= 34
bignumeric
decimal(p,s), 35 <= p <= 54, 0 <= s <= 35
bignumeric
decimal(p,s), 36 <= p <= 55, 0 <= s <= 36
bignumeric
decimal(p,s), 37 <= p <= 56, 0 <= s <= 37
bignumeric
decimal(p,s), 38 <= p <= 56, 0 <= s <= 38
bignumeric
decimal(p,s), 39 <= p <= 40, 0 <= s <= 39
string
decimal(p,s), 39 <= p <= 40, 21 <= s <= 38
bignumeric
decimal(p,s), 40 <= p <= 41, 0 <= s <= 40
string
decimal(p,s), 41 <= p <= 42, 0 <= s <= 41
string
decimal(p,s), 42 <= p <= 43, 0 <= s <= 42
string
decimal(p,s), 43 <= p <= 44, 0 <= s <= 43
string
decimal(p,s), 44 <= p <= 63, 0 <= s <= 44
string
decimal(p,s), 45 <= p <= 46, 0 <= s <= 45
string
decimal(p,s), 46 <= p <= 47, 0 <= s <= 46
string
decimal(p,s), 47 <= p <= 48, 0 <= s <= 47
string
decimal(p,s), 48 <= p <= 49, 0 <= s <= 48
string
decimal(p,s), 49 <= p <= 50, 0 <= s <= 49
string
decimal(p,s), 50 <= p <= 51, 0 <= s <= 50
string
decimal(p,s), 51 <= p <= 52, 0 <= s <= 51
string
decimal(p,s), 52 <= p <= 53, 0 <= s <= 52
string
decimal(p,s), 53 <= p <= 54, 0 <= s <= 53
string
decimal(p,s), 54 <= p <= 55, 0 <= s <= 54
string
decimal(p,s), 55 <= p <= 56, 0 <= s <= 55
string
decimal(p,s), 56 <= p <= 57, 0 <= s <= 56
string
decimal(p,s), 56 <= p <= 63, 39 <= s <= 62
string
decimal(p,s), 57 <= p <= 58, 0 <= s <= 57
string
decimal(p,s), 58 <= p <= 59, 0 <= s <= 58
string
decimal(p,s), 59 <= p <= 60, 0 <= s <= 59
string
decimal(p,s), 60 <= p <= 61, 0 <= s <= 60
string
decimal(p,s), 61 <= p <= 62, 0 <= s <= 61
string
decimal(p,s), 62 <= p <= 63, 0 <= s <= 62
string
decimal(p,s), 9 <= p <= 38, 1 <= s <= 9
numeric
float
float64
integer
int64
long varbinary
bytes
long varchar
string
long varchar for bit data
bytes
numeric(1,1)
numeric
numeric(10,10)
bignumeric
numeric(11,s), 10 <= s <= 11
bignumeric
numeric(12,s), 10 <= s <= 12
bignumeric
numeric(13,s), 10 <= s <= 13
bignumeric
numeric(14,s), 10 <= s <= 14
bignumeric
numeric(15,s), 10 <= s <= 15
bignumeric
numeric(16,s), 10 <= s <= 16
bignumeric
numeric(17,s), 10 <= s <= 17
bignumeric
numeric(18,s), 10 <= s <= 18
bignumeric
numeric(19,s), 10 <= s <= 19
bignumeric
numeric(2,s), 1 <= s <= 2
numeric
numeric(20,s), 10 <= s <= 20
bignumeric
numeric(21,s), 10 <= s <= 21
bignumeric
numeric(22,s), 10 <= s <= 22
bignumeric
numeric(23,s), 10 <= s <= 23
bignumeric
numeric(24,s), 10 <= s <= 24
bignumeric
numeric(25,s), 10 <= s <= 25
bignumeric
numeric(26,s), 10 <= s <= 26
bignumeric
numeric(27,s), 10 <= s <= 27
bignumeric
numeric(28,s), 10 <= s <= 28
bignumeric
numeric(3,s), 1 <= s <= 3
numeric
numeric(4,s), 1 <= s <= 4
numeric
numeric(5,s), 1 <= s <= 5
numeric
numeric(6,s), 1 <= s <= 6
numeric
numeric(7,s), 1 <= s <= 7
numeric
numeric(8,s), 1 <= s <= 8
numeric
numeric(p,0), 1 <= p <= 18
int64
numeric(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
numeric(p,s), 29 <= p <= 48, 0 <= s <= 29
bignumeric
numeric(p,s), 30 <= p <= 49, 0 <= s <= 30
bignumeric
numeric(p,s), 31 <= p <= 50, 0 <= s <= 31
bignumeric
numeric(p,s), 32 <= p <= 51, 0 <= s <= 32
bignumeric
numeric(p,s), 33 <= p <= 52, 0 <= s <= 33
bignumeric
numeric(p,s), 34 <= p <= 53, 0 <= s <= 34
bignumeric
numeric(p,s), 35 <= p <= 54, 0 <= s <= 35
bignumeric
numeric(p,s), 36 <= p <= 55, 0 <= s <= 36
bignumeric
numeric(p,s), 37 <= p <= 56, 0 <= s <= 37
bignumeric
numeric(p,s), 38 <= p <= 56, 0 <= s <= 38
bignumeric
numeric(p,s), 39 <= p <= 40, 0 <= s <= 39
string
numeric(p,s), 39 <= p <= 40, 21 <= s <= 38
bignumeric
numeric(p,s), 40 <= p <= 41, 0 <= s <= 40
string
numeric(p,s), 41 <= p <= 42, 0 <= s <= 41
string
numeric(p,s), 42 <= p <= 43, 0 <= s <= 42
string
numeric(p,s), 43 <= p <= 44, 0 <= s <= 43
string
numeric(p,s), 44 <= p <= 63, 0 <= s <= 44
string
numeric(p,s), 45 <= p <= 46, 0 <= s <= 45
string
numeric(p,s), 46 <= p <= 47, 0 <= s <= 46
string
numeric(p,s), 47 <= p <= 48, 0 <= s <= 47
string
numeric(p,s), 48 <= p <= 49, 0 <= s <= 48
string
numeric(p,s), 49 <= p <= 50, 0 <= s <= 49
string
numeric(p,s), 50 <= p <= 51, 0 <= s <= 50
string
numeric(p,s), 51 <= p <= 52, 0 <= s <= 51
string
numeric(p,s), 52 <= p <= 53, 0 <= s <= 52
string
numeric(p,s), 53 <= p <= 54, 0 <= s <= 53
string
numeric(p,s), 54 <= p <= 55, 0 <= s <= 54
string
numeric(p,s), 55 <= p <= 56, 0 <= s <= 55
string
numeric(p,s), 56 <= p <= 57, 0 <= s <= 56
string
numeric(p,s), 56 <= p <= 63, 39 <= s <= 62
string
numeric(p,s), 57 <= p <= 58, 0 <= s <= 57
string
numeric(p,s), 58 <= p <= 59, 0 <= s <= 58
string
numeric(p,s), 59 <= p <= 60, 0 <= s <= 59
string
numeric(p,s), 60 <= p <= 61, 0 <= s <= 60
string
numeric(p,s), 61 <= p <= 62, 0 <= s <= 61
string
numeric(p,s), 62 <= p <= 63, 0 <= s <= 62
string
numeric(p,s), 9 <= p <= 38, 1 <= s <= 9
numeric
real
float64
rowid
bytes
smallint
int64
time
time
timestamp(precision), 0 <= p <= 6
datetime
timestamp(precision), 7 <= p <= 12
string
varbinary(size), 1 <= size <= 32740
bytes
varchar(size) for bit data, 1 <= size <= 32740
bytes
varchar(size), 1 <= size <= 32740
string
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for i data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for i Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for i source and a Microsoft Azure Synapse Analytics target:
Db2 for i Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
bigint
bigint
binary(size), 1 <= size <= 8000
binary(size), 1 <= size <= 8000
binary(size), 8001 <= size <= 32766
varbinary(max)
char(size) for bit data, 1 <= size <= 8000
binary(size), 1 <= size <= 8000
char(size) for bit data, 8001 <= size <= 32766
varbinary(max)
char(size), 1 <= size <= 8000
char(size), 1 <= size <= 8000
char(size), 8001 <= size <= 32766
varchar(max)
date
date
decfloat(precision), 16 <= p <= 34
varchar(255)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 39 <= p <= 63, 0 <= s <= 62
char(size), 40 <= size <= 65
float
float
integer
int
long varbinary
varbinary(max)
long varchar
varchar(max)
long varchar for bit data
varbinary(max)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 39 <= p <= 63, 0 <= s <= 62
char(size), 40 <= size <= 65
real
real
rowid
varbinary(40)
smallint
smallint
time
time(0)
timestamp(precision), 0 <= p <= 7
datetime2(precision), 0 <= p <= 7
timestamp(precision), 8 <= p <= 12
char(size), 28 <= size <= 32
varbinary(size), 1 <= size <= 32740
varbinary(size), 1 <= size <= max
varchar(size) for bit data, 1 <= size <= 32740
varbinary(size), 1 <= size <= max
varchar(size), 1 <= size <= 32740
varchar(size), 1 <= size <= max
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for i data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for i Source and Microsoft SQL Server Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for i source and a Microsoft SQL Server target:
Db2 for i Source Data Type
Microsoft SQL Server Target Data Type
bigint
bigint
binary(size), 1 <= size <= 8000
varbinary(n), 1 <= n <= 8000
binary(size), 8001 <= size <= 32766
varbinary(max)
char(size) for bit data, 1 <= size <= 8000
varbinary(n), 1 <=n <= 8000
char(size) for bit data, 8001 <= size <= 32766
varbinary(max)
char(size), 1 <= size <= 8000
varchar(n), 1 <= n <= 8000
char(size), 8001 <= size <= 32766
varchar(max)
date
date
decfloat(precision), 16 <= p <= 34
varchar(255)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 39 <= p <= 63, 0 <= s <= 62
char(n), 40 <= n <= 65
float
float
integer
int
long varbinary
varbinary(max)
long varchar
varchar(max)
long varchar for bit data
varbinary(max)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 39 <= p <= 63, 0 <= s <= 62
char(n), 40 <= n <= 65
real
real
rowid
varbinary(40)
smallint
smallint
time
time(0)
timestamp(precision), 0 <= p <= 7
datetime2(precision), 0 <= p <= 7
timestamp(precision), 8 <= p <= 12
char(n), 28 <= n <= 32
varbinary(size), 1 <= size <= 32740
varbinary(n), 1 <= n <= max
varchar(size) for bit data, 1 <= size <= 32740
varbinary(n), 1 <= n <= max
varchar(size), 1 <= size <= 32740
varchar(n), 1 <= n <= max
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for i data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for i Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for i source and an Oracle target:
Db2 for i Source Data Type
Oracle Target Data Type
bigint
number(19)
binary(size), 1 <= s <= 2000
raw(size), 1 <= size <= 2000
binary(size), 2001 <= s <= 32766
blob
char(size) for bit data, 1 <= s <= 32766
blob
char(size), 1 <= s <= 2000
char(s byte), 1 <= s <= 2000
char(size), 2001 <= s <= 4000
varchar2(s byte), 2001 <= s <= 4000
char(size), 4001 <= s <= 32766
clob
date
date
decfloat(precision), 16 <= p <= 34
char(255 char)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
number(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 39 <= p <= 63, 0 <= s <= 62
char(s char), 40 <= s <= 65
float
binary_double
integer
number(10)
long varbinary
blob
long varchar
clob
long varchar for bit data
blob
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
number(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 39 <= p <= 63, 0 <= s <= 62
char(s char), 40 <= s <= 65
real
binary_double
rowid
blob
smallint
number(5)
time
char(8 char)
timestamp(0)
date
timestamp(precision), 1 <= p <= 9
timestamp(precision), 1 <= p <= 9
timestamp(precision), 10 <= p <= 12
char(s char), 30 <= s <= 32
varbinary(size), 1 <= size <= 2000
raw(size), 1 <= size <= 2000
varbinary(size), 2001 <= size <= 32740
blob
varchar(size) for bit data, 1 <= size <= 32740
blob
varchar(size), 1 <= size <= 4000
varchar2(s byte), 1 <= s <= 4000
varchar(size), 4001 <= size <= 32740
clob
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for i data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for i Source and PostgreSQL Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for i source and a PostgreSQL target:
Db2 for i Source Data Type
PostgreSQL Target Data Type
bigint
bigint
binary(size), 1 <= size <= 32766
bytea
char(size) for bit data, 1 <= size <= 32766
bytea
char(size), 1 <= size <= 32766
character varying(size), 1 <= size <= 32766
date
date
decfloat(precision), 16 <= p <= 34
character varying(255)
decimal(p,s), 1 <= p <= 63, 0 <= s <= 62
numeric(p,s), 1 <= p <= 63, 0 <= s <= 62
float
double precision
integer
integer
long varbinary
bytea
long varchar
text
long varchar for bit data
bytea
numeric(p,s), 1 <= p <= 63, 0 <= s <= 62
numeric(p,s), 1 <= p <= 63, 0 <= s <= 62
real
real
rowid
bytea
smallint
smallint
time
time(0) without time zone
timestamp(precision), 0 <= p <= 6
timestamp(precision) without time zone, 0 <= p <= 6
timestamp(precision), 7 <= p <= 12
character varying(size), 27 <= size <= 32
varbinary(size), 1 <= size <= 32740
bytea
varchar(size) for bit data, 1 <= size <= 32740
bytea
varchar(size), 1 <= size <= 32740
character varying(size), 1 <= size <= 32740
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for i data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for i Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for i source and a Snowflake target:
Db2 for i Source Data Type
Snowflake Target Data Type
bigint
integer
binary(size), 1 <= size <= 32766
binary(size), 1 <= size <= 32766
char(size) for bit data, 1 <= size <= 32766
binary(size), 1 <= size <= 32766
char(size), 1 <= size <= 32766
char(size), 4 <= size <= 131064
date
date
decfloat(precision), 16 <= p <= 34
char(255)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37
number(p,s), 1 <= p <= 38, 0 <= s <= 37
decimal(p,s), 38 <= p <= 63, 0 <= s <= 62
char(size), 40 <= size <= 65
float
float
integer
integer
long varbinary
binary
long varchar
varchar
long varchar for bit data
binary
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
number(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 38 <= p <= 63, 0 <= s <= 62
char(size), 40 <= size <= 65
real
float
rowid
binary(40)
smallint
integer
time
time(0)
timestamp(precision), 0 <= p <= 9
timestamp_ntz(precision), 0 <= p <= 9
timestamp(precision), 10 <= p <= 12
char(size), 30 <= size <= 32
varbinary(size), 1 <= size <= 32740
binary(size), 1 <= size <= 32740
varchar(size) for bit data, 1 <= size <= 32740
binary(size), 1 <= size <= 32740
varchar(size), 1 <= size <= 32740
varchar(size), 4 <= size <= 130960
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for i data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for LUW Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for Linux, UNIX, and Windows (LUW) source and an Amazon Redshift target:
Db2 for LUW Source Data Type
Amazon Redshift Target Data Type
bigint
bigint
binary(size), 1 <= size <= 255
binary varying(size), 1 <= size <= 255
boolean
boolean
char for bit data
binary varying(1)
char(size) for bit data, 2 <= size <= 255
binary varying(size), 2 <= size <= 255
character(size), 1 <= s <= 255
character(size), 4 <= size <= 1020
date
date
decfloat(precision), 16 <= p <= 34
character varying(255)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
numeric(p,s), 1 <= p <= 31, 0 <= s <= 31
double
double precision
integer
integer
long varchar
character varying(65535)
long varchar for bit data
binary varying(32700)
real
real
smallint
smallint
time
time without time zone
timestamp(precision), 0 <= p <= 6
timestamp without time zone
timestamp(precision), 7 <= p <= 12
character varying(size), 27 <= size <= 32
varbinary(size), 1 <= size <= 32672
binary varying(size), 1 <= size <= 32672
varchar(size) for bit data, 1 <= size <= 32672
binary varying(size), 1 <= size <= 32672
varchar(size), 1 <= size <= 32672
character varying(size), 4 <= size <= 65535

Db2 for LUW Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for Linux, UNIX, and Windows (LUW) source and a Databricks target:
Db2 for LUW Source Data Type
Databricks Target Data Type
bigint
long
binary(size), 1 <= size <= 255
binary
boolean
boolean
char for bit data
binary
char(size) for bit data, 2 <= size <= 255
binary
character(size), 1 <= size <= 255
string
date
string
decfloat(precision), 16 <= p <= 34
string
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
double
double
integer
integer
long varchar
string
long varchar for bit data
binary
real
float
smallint
integer
time
string
timestamp(precision), 0 <= p <= 6
timestamp
timestamp(precision), 7 <= p <= 12
string
varbinary(size), 1 <= size <= 32672
binary
varchar(size) for bit data, 1 <= size <= 32672
binary
varchar(size), 1 <= size <= 32672
string

Db2 for LUW Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for Linux, UNIX, and Windows (LUW) source and a Google BigQuery target:
Db2 for LUW Source Data Type
Google BigQuery Target Data Type
bigint
int64
binary(size), 1 <= size <= 255
bytes
boolean
bool
char for bit data
bytes
char(size) for bit data, 2 <= size <= 255
bytes
character(size), 1 <= size <= 255
string
date
date
decfloat(precision), 16 <= p <= 34
string
decimal(1,1)
numeric
decimal(10,10)
bignumeric
decimal(11,s), 10 <= s <= 11
bignumeric
decimal(12,s), 10 <= s <= 12
bignumeric
decimal(13,s), 10 <= s <= 13
bignumeric
decimal(14,s), 10 <= s <= 14
bignumeric
decimal(15,s), 10 <= s <= 15
bignumeric
decimal(16,s), 10 <= s <= 16
bignumeric
decimal(17,s), 10 <= s <= 17
bignumeric
decimal(18,s), 10 <= s <= 18
bignumeric
decimal(19,s), 10 <= s <= 19
bignumeric
decimal(2,s), 1 <= s <= 2
numeric
decimal(20,s), 10 <= s <= 20
bignumeric
decimal(21,s), 10 <= s <= 21
bignumeric
decimal(22,s), 10 <= s <= 22
bignumeric
decimal(23,s), 10 <= s <= 23
bignumeric
decimal(24,s), 10 <= s <= 24
bignumeric
decimal(25,s), 10 <= s <= 25
bignumeric
decimal(26,s), 10 <= s <= 26
bignumeric
decimal(27,s), 10 <= s <= 27
bignumeric
decimal(28,s), 10 <= s <= 28
bignumeric
decimal(3,s), 1 <= s <= 3
numeric
decimal(31,s), 10 <= s <= 31
bignumeric
decimal(4,s), 1 <= s <= 4
numeric
decimal(5,s), 1 <= s <= 5
numeric
decimal(6,s), 1 <= s <= 6
numeric
decimal(7,s), 1 <= s <= 7
numeric
decimal(8,s), 1 <= s <= 8
numeric
decimal(p,0), 1 <= p <= 18
int64
decimal(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
decimal(p,s), 29 <= p <= 30, 0 <= s <= 29
bignumeric
decimal(p,s), 30 <= p <= 31, 0 <= s <= 30
bignumeric
decimal(p,s), 9 <= p <= 31, 1 <= s <= 9
numeric
double
float64
integer
int64
long varchar
string
long varchar for bit data
bytes
real
float64
smallint
int64
time
time
timestamp(precision), 0 <= p <= 6
datetime
timestamp(precision), 7 <= p <= 12
string
varbinary(size), 1 <= s <= 32672
bytes
varchar(size) for bit data, 1 <= size <= 32672
bytes
varchar(size), 1 <= size <= 32672
string

Db2 for LUW Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for Linux, UNIX, and Windows (LUW) source and a Microsoft Azure Synapse Analytics target:
Db2 for LUW Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
bigint
bigint
binary(size), 1 <= size <= 255
binary(size), 1 <= size <= 255
blob
varbinary(max)
boolean
bit
char for bit data
binary
char(size) for bit data, 2 <= size <= 255
binary(size), 2 <= size <= 255
char(size), 1 <= size <= 255
char(size), 1 <= size <= 255
clob
varchar(max)
date
date
dbclob
varchar(max)
decfloat(precision), 16 <= p <= 34
varchar(255)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
double
float
integer
int
long varchar
varchar(max)
long varchar for bit data
varbinary(max)
long vargraphic
varchar(max)
real
real
smallint
smallint
time
time(0)
timestamp(precision), 0 <= p <= 7
datetime2(precision), 0 <= p <= 7
timestamp(precision), 8 <= p <= 12
char(size), 28 <= size <= 32
varbinary(size), 1 <= size <= 32672
varbinary(size), 1 <= size <= max
varchar(size) for bit data, 1 <= size <= 32672
varbinary(size), 1 <= size <= max
varchar(size), 1 <= size <= 32672
varchar(size), 1 <= size <= max
xml
varchar(max)

Db2 for LUW Source and Microsoft SQL Server Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for Linux, UNIX, and Windows (LUW) source and a Microsoft SQL Server target:
Db2 for LUW Source Data Type
Microsoft SQL Server Target Data Type
bigint
bigint
binary(size), 1 <= size <= 255
varbinary(size), 1 <= size <= 255
boolean
bit
char for bit data
varbinary
char(size) for bit data, 2 <= size <= 255
varbinary(size), 2 <= size <= 255
character(size), 1 <= size <= 255
varchar(size), 1 <= size <= 255
date
date
decfloat(precision), 16 <= p <= 34
varchar(255)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
double
float
integer
int
long varchar
varchar(max)
long varchar for bit data
varbinary(max)
real
real
smallint
smallint
time
time(0)
timestamp(precision), 0 <= p <= 7
datetime2(precision), 0 <= p <= 7
timestamp(precision), 8 <= p <= 12
varchar(size), 28 <= size <= 32
varbinary(size), 1 <= size <= 32672
varbinary(size), 1 <= size <= max
varchar(size) for bit data, 1 <= size <= 32672
varbinary(size), 1 <= size <= max
varchar(size), 1 <= size <= 32672
varchar(size), 1 <= size <= max

Db2 for LUW Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for Linux, UNIX, and Windows (LUW) source and an Oracle target:
Db2 for LUW Source Data Type
Oracle Target Data Type
bigint
number(19)
binary(size), 1 <= size <= 255
raw(size), 1 <= size <= 255
boolean
char(1 char)
char for bit data
raw(1)
char(size) for bit data, 2 <= size <= 255
raw(size), 2 <= size <= 255
character(size), 1 <= size <= 255
varchar2(s byte), 1 <= s <= 255
date
date
decfloat(precision), 16 <= p <= 34
varchar2(255 char)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
number(p,s), 1 <= p <= 31, 0 <= s <= 31
double
binary_double
integer
number(10)
long varchar
clob
long varchar for bit data
blob
real
binary_float
smallint
number(5)
time
timestamp(0)
timestamp(0)
date
timestamp(precision), 1 <= p <= 9
timestamp(precision), 1 <= p <= 9
timestamp(precision), 10 <= p <= 12
char(s char), 30 <= s <= 32
varbinary(size), 1 <= size <= 1501
raw(size), 1 <= size <= 1501
varbinary(size), 2001 <= size <= 32672
blob
varchar(size) for bit data, 1 <= size <= 1501
raw(size), 1 <= size <= 1501
varchar(size) for bit data, 2001 <= size <= 32672
blob
varchar(size), 1 <= size <= 3501
varchar2(s byte), 1 <= s <= 3501
varchar(size), 4001 <= size <= 32672
clob

Db2 for LUW Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for Linux, UNIX, and Windows (LUW) source and a Snowflake target:
Db2 for LUW Source Data Type
Snowflake Target Data Type
bigint
integer
binary(size), 1 <= size <= 255
binary(size), 1 <= size <= 255
blob
binary(size), 1 <= size <= max
boolean
boolean
char for bit data
binary(1)
char(size) for bit data, 2 <= size <= 255
binary(size), 2 <= size <= 255
character(size), 1 <= size <= 255
char(size), 4 <= size <= 1020
clob
varchar( size ), 4 <= size <= max
date
date
dbclob
varchar( size ), 4 <= size <= max
decfloat(precision), 16 <= p <= 34
char(255)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
number(p,s), 1 <= p <= 31, 0 <= s <= 31
double
float
integer
integer
long varchar
varchar(size), 4 <= size <= 130800
long varchar for bit data
binary(size), 1 <= size <= 32700
long vargraphic
varchar( size ), 4 <= size <= 65400
real
float
smallint
integer
time
time(0)
timestamp(precision), 0 <= p <= 9
timestamp_ntz(precision), 0 <= p <= 9
timestamp(precision), 10 <= p <= 12
char(size), 30 <= size <= 32
varbinary(size), 1 <= size <= 32672
binary(size), 1 <= size <= 32672
varchar(size) for bit data, 1 <= size <= 32672
binary(size), 1 <= size <= 32672
varchar(size), 1 <= size <= 32672
varchar(size), 4 <= size <= 130688
xml
varchar(size), 4 <= size <= max

Db2 for z/OS Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for z/OS source and an Amazon Redshift target:
Db2 for z/OS Source Data Type
Amazon Redshift Target Data Type
bigint
bigint
binary(size), 1 <= size <= 255
binary varying(size), 1 <= size <= 255
char for bit data
binary varying(1)
char(size) for bit data, 2 <= size <= 255
binary varying(size), 2 <= size <= 255
char(size), 1 <= size <= 255
character(size), 4 <= size <= 1020
date
date
decfloat(precision), 16 <= p <= 34
character varying(255)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
numeric(p,s), 1 <= p <= 31, 0 <= s <= 31
float
double precision
integer
integer
long varchar
character varying(65535)
long varchar for bit data
binary varying(32704)
real
real
rowid
binary varying(40)
smallint
smallint
time
time without time zone
timestamp(precision) with time zone, 0 <= p <= 6
timestamp with time zone
timestamp(precision) with time zone, 7 <= p <= 12
character varying(size), 67 <= size <= 72
timestamp(precision), 0 <= p <= 6
timestamp without time zone
timestamp(precision), 7 <= p <= 12
character varying(size), 27 <= size <= 32
varbinary(size), 1 <= size <= 32704
binary varying(size), 1 <= size <= 32704
varchar(size) for bit data, 1 <= size <= 32704
binary varying(size), 1 <= size <= 32704
varchar(size), 1 <= size <= 32704
character varying(size), 4 <= size <= 65535
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for z/OS data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for z/OS Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for z/OS source and a Databricks target:
Db2 for z/OS Source Data Type
Databricks Target Data Type
bigint
long
binary(size), 1 <= size <= 255
binary
char for bit data
binary
char(size) for bit data, 2 <= size <= 255
binary
char(size), 1 <= size <= 255
string
date
string
decfloat(precision), 16 <= p <= 34
string
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
float
double
integer
integer
long varchar
string
long varchar for bit data
binary
real
float
rowid
binary
smallint
integer
time
string
timestamp(precision) with time zone, 0 <= p <= 12
string
timestamp(precision), 0 <= p <= 6
timestamp
timestamp(precision), 7 <= p <= 12
string
varbinary(size), 1 <= size <= 32704
binary
varchar(size) for bit data, 1 <= size <= 32704
binary
varchar(size), 1 <= size <= 32704
string
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for z/OS data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for z/OS Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for z/OS source and a Google BigQuery target:
Db2 for z/OS Source Data Type
Google BigQuery Target Data Type
bigint
int64
binary(size), 1 <= size <= 255
bytes
char for bit data
bytes
char(size) for bit data, 2 <= size <= 255
bytes
char(size), 1 <= size <= 255
string
date
date
decfloat(precision), 16 <= p <= 34
string
decimal(1,1)
numeric
decimal(10,10)
bignumeric
decimal(11,s), 10 <= s <= 11
bignumeric
decimal(12,s), 10 <= s <= 12
bignumeric
decimal(13,s), 10 <= s <= 13
bignumeric
decimal(14,s), 10 <= s <= 14
bignumeric
decimal(15,s), 10 <= s <= 15
bignumeric
decimal(16,s), 10 <= s <= 16
bignumeric
decimal(17,s), 10 <= s <= 17
bignumeric
decimal(18,s), 10 <= s <= 18
bignumeric
decimal(19,s), 10 <= s <= 19
bignumeric
decimal(2,s), 1 <= s <= 2
numeric
decimal(20,s), 10 <= s <= 20
bignumeric
decimal(21,s), 10 <= s <= 21
bignumeric
decimal(22,s), 10 <= s <= 22
bignumeric
decimal(23,s), 10 <= s <= 23
bignumeric
decimal(24,s), 10 <= s <= 24
bignumeric
decimal(25,s), 10 <= s <= 25
bignumeric
decimal(26,s), 10 <= s <= 26
bignumeric
decimal(27,s), 10 <= s <= 27
bignumeric
decimal(28,s), 10 <= s <= 28
bignumeric
decimal(3,s), 1 <= s <= 3
numeric
decimal(31,s), 10 <= s <= 31
bignumeric
decimal(4,s), 1 <= s <= 4
numeric
decimal(5,s), 1 <= s <= 5
numeric
decimal(6,s), 1 <= s <= 6
numeric
decimal(7,s), 1 <= s <= 7
numeric
decimal(8,s), 1 <= s <= 8
numeric
decimal(p,0), 1 <= p <= 18
int64
decimal(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
decimal(p,s), 29 <= p <= 30, 0 <= s <= 29
bignumeric
decimal(p,s), 30 <= p <= 31, 0 <= s <= 30
bignumeric
decimal(p,s), 9 <= p <= 31, 1 <= s <= 9
numeric
float
float64
integer
int64
long varchar
string
long varchar for bit data
bytes
real
float64
rowid
bytes
smallint
int64
time
time
timestamp(precision) with time zone, 0 <= p <= 6
timestamp
timestamp(precision) with time zone, 7 <= p <= 12
string
timestamp(precision), 0 <= p <= 6
datetime
timestamp(precision), 7 <= p <= 12
string
varbinary(size), 1 <= size <= 32704
bytes
varchar(size) for bit data, 1 <= size <= 32704
bytes
varchar(size), 1 <= size <= 32704
string
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for z/OS data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for z/OS Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for z/OS source and a Microsoft Azure Synapse Analytics target:
Db2 for z/OS Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
bigint
bigint
binary(size), 1 <= size <= 255
binary(size), 1 <= size <= 255
char for bit data
binary
char(size) for bit data, 2 <= size <= 255
binary(size), 2 <= size <= 255
char(size), 1 <= size <= 255
char(size), 1 <= size <= 255
date
date
decfloat(precision), 16 <= p <= 34
varchar(255)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
float
float
integer
int
long varchar
varchar(max)
long varchar for bit data
varbinary(max)
real
real
rowid
varbinary(40)
smallint
smallint
time
time(0)
timestamp(precision) with time zone, 0 <= p <= 7
datetimeoffset(precision), 0 <= p <= 7
timestamp(precision) with time zone, 8 <= p <= 12
char(size), 68 <= size <= 72
timestamp(precision), 0 <= p <= 7
datetime2(precision), 0 <= p <= 7
timestamp(precision), 8 <= p <= 12
char(size), 28 <= size <= 32
varbinary(size), 1 <= size <= 32704
varbinary(size), 1 <= size <= max
varchar(size) for bit data, 1 <= size <= 32704
varbinary(size), 1 <= size <= max
varchar(size), 1 <= size <= 32704
varchar(size), 1 <= size <= max
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for z/OS data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for z/OS Source and Microsoft SQL Server Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for z/OS source and a Microsoft SQL Server target:
Db2 for z/OS Source Data Type
Microsoft SQL Server Target Data Type
bigint
bigint
binary(p), 1 <= p <= 255
varbinary(p), 1 <= p <= 255
char(p) for bit data, 1<= p <= 255
varbinary(p), 1 <= p <= 255
char(p), 1 <= size <= 255
varchar(p), 1 <= p <= 255
date
date
decfloat(p), 16 <= p <= 34
varchar(255)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
float
float
integer
int
long varchar
varchar(max)
long varchar for bit data
geography
real
real
rowid
varbinary(40)
smallint
smallint
time
time(0)
timestamp(p) with time zone, 0 <= p <= 7
datetimeoffset(p), 0 <= p <= 7
timestamp(p) with time zone, 8 <= p <= 12
char(p), 68 <= p <= 72
timestamp(p), 0 <= p <= 7
datetime2(p), 0 <= p <= 7
timestamp(p), 8 <= p <= 12
char(p), 28 <= p <= 32
varbinary(p), 1 <= size <= 32704
varbinary(p), 1 <= p <= max
varchar(p) for bit data, 1 <= size <= 32704
varbinary(p), 1 <= p <= max
varchar(p), 1 <= size <= 32704
varchar(p), 1 <= p <= max
Note: In this table, p is precision and s is size.
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for z/OS data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for z/OS Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for z/OS source and an Oracle target:
Db2 for z/OS Source Data Type
Oracle Target Data Type
bigint
number(19)
binary(size), 1 <= size <= 255
raw(size), 1 <= size <= 255
char for bit data
blob
char(size) for bit data, 2 <= size <= 255
blob
char(size), 1 <= size <= 255
char(s byte), 1 <= s <= 255
date
date
decfloat(precision), 16 <= p <= 34
char(255 char)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
number(p,s), 1 <= p <= 31, 0 <= s <= 31
float
binary_double
integer
number(10)
long varchar
clob
long varchar for bit data
blob
real
binary_double
rowid
blob
smallint
number(5)
time
char(8 char)
timestamp(0)
date
timestamp(precision) with time zone, 0 <= p <= 9
timestamp(precision) with time zone, 0 <= p <= 9
timestamp(precision) with time zone, 10 <= p <= 12
char(s char), 70 <= s <= 72
timestamp(precision), 1 <= p <= 9
timestamp(precision), 1 <= p <= 9
timestamp(precision), 10 <= p <= 12
char(s char), 30 <= s <= 32
varbinary(size), 1 <= size <= 2000
raw(size), 1 <= size <= 2000
varbinary(size), 2001 <= size <= 32704
blob
varchar(size) for bit data, 1 <= size <= 32704
blob
varchar(size), 1 <= size <= 3501
varchar2(s byte), 1 <= s <= 3501
varchar(size), 4001 <= size <= 32704
clob
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for z/OS data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Db2 for z/OS Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for z/OS source and a Snowflake target:
Db2 for z/OS Source Data Type
Snowflake Target Data Type
bigint
integer
binary(size), 1 <= size <= 255
binary(size), 1 <= size <= 255
char for bit data
binary(1)
char(size) for bit data, 2 <= size <= 255
binary(size), 2 <= size <= 255
char(size), 1 <= size <= 255
char(size), 4 <= size <= 1020
date
date
decfloat(precision), 16 <= p <= 34
char(255)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
number(p,s), 1 <= p <= 31, 0 <= s <= 31
float
float
integer
integer
long varchar
varchar(130816)
long varchar for bit data
binary(32704)
real
float
rowid
binary(40)
smallint
integer
time
time(0)
timestamp(precision) with time zone, 0 <= p <= 9
timestamp_tz(precision), 0 <= p <= 9
timestamp(precision) with time zone, 10 <= p <= 12
char(size), 70 <= s <= 72
timestamp(precision), 0 <= p <= 9
timestamp_ntz(precision), 0 <= p <= 9
timestamp(precision), 10 <= p <= 12
char(size), 30 <= size <= 32
varbinary(size), 1 <= size <= 32704
binary(size), 1 <= size <= 32704
varchar(size) for bit data, 1 <= size <= 32704
binary(size), 1 <= size <= 32704
varchar(size), 1 <= size <= 32704
varchar(size), 4 <= size <= 130816
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for z/OS data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.

Microsoft SQL Server or Azure SQL Database Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Microsoft SQL Server or Azure SQL Database source and an Amazon Redshift target:
Microsoft SQL Server or Azure SQL Database Source Data Type
Amazon Redshift Target Data Type
bigint
bigint
binary(size), 1 <= size <= 8000
binary varying(size), 1 <= size <= 8000
bit
boolean
char(size), 1 <= size <= 8000
character varying(size), 1 <= size <= 8000
date
date
datetime
timestamp without time zone
datetime2(7)
character varying(27)
datetime2(precision), 0 <= p <= 6
timestamp without time zone
datetimeoffset(7)
character varying(67)
datetimeoffset(precision), 0 <= p <= 6
timestamp with time zone
decimal(38,38)
character varying(41)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
float
double precision
geography
binary varying(1024000)
geometry
binary varying(1024000)
hierarchyid
binary varying(892)
image
binary varying(1024000)
int
integer
money
numeric(20,4)
nchar(size), 1 <= size <= 4000
character varying(size), 1 <= size <= 8000
ntext
character varying(65535)
numeric(38,38)
character varying(41)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
nvarchar(size), 1 <= size <= 4000
character varying(size), 1 <= size <= 8000
real
real
smalldatetime
timestamp without time zone
smallint
smallint
smallmoney
numeric(10,4)
sql_variant
binary varying(8016)
text
character varying(65535)
time(precision), 0 <= p <= 7
varchar(16)
timestamp(8)
binary varying(8)
tinyint
smallint
uniqueidentifier
character(36)
varbinary(size), 1 <= size <= 8000
binary varying(size), 1 <= size <= 8000
varchar(size), 1 <= size <= 8000
character varying(size), 1 <= size <= 8000
xml
character varying(65535)
LOB limitations
Database ingestion and replication initial load jobs can replicate data from SQL Server GEOGRAPHY, GEOMETRY, IMAGE, NTEXT, NVARCHAR(MAX), TEXT, VARBINARY(MAX), VARCHAR(MAX), and XML columns to Amazon Redshift targets. LOB data might be truncated before being written to the target. The truncation point depends on the data type and target type. For initial load jobs with an Amazon Redshift target, GEOGRAPHY, GEOMETRY, IMAGE and VARBINARY(MAX) data is truncated to 1024000 bytes, and NTEXT, NVARCHAR(MAX), TEXT, VARCHAR(MAX), and XML data is truncated to 65535 bytes. For more information, see the "Include LOBs" description in Configure a Microsoft SQL Server source.
Unsupported source data types
None.

Microsoft SQL Server Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Microsoft SQL Server source and a Databricks target:
Microsoft SQL Server Source Data Type
Databricks Target Data Type
bigint
bigint
binary(size), 1 <= size <= 8000
binary
bit
boolean
char(size), 1 <= size <= 8000
string
date
string
datetime
timestamp
datetime2(7)
string
datetime2(precision), 0 <= p <= 6
timestamp
datetimeoffset(7)
string
datetimeoffset(precision), 0 <= p <= 6
timestamp
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
float
double
geography
binary
geometry
binary
hierarchyid
binary
image
binary
int
integer
money
decimal(19,4)
nchar(size), 1 <= size <= 4000
string
ntext
string
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
nvarchar(size), 1 <= size <= 4000
string
real
float
smalldatetime
timestamp
smallint
integer
smallmoney
decimal(10,4)
sql_variant
binary
text
string
time(precision), 0 <= p <= 7
string
timestamp(8)
binary
tinyint
integer
uniqueidentifier
string
varbinary(size), 1 <= size <= 8000
binary
varchar(size), 1 <= size <= 8000
string
xml
string
LOB limitations
Database ingestion and replication jobs that use any of the load types can replicate data from SQL Server GEOGRAPHY, GEOMETRY, IMAGE, NTEXT, NVARCHAR(MAX), TEXT, VARBINARY(MAX), VARCHAR(MAX), and XML columns to Databricks targets. LOB data might be truncated before being written to the target. The truncation point depends on the data type and load type. For initial load jobs with a Databricks target, the truncation point for all SQL Server LOB data types is 16777216 bytes. For incremental loads and combined loads, if LOB columns contain more than 8 KB of data, the data is truncated to 4000 bytes if stored inline or to approximately 8000 bytes if stored out-of-line. For more information, see the "Include LOBs" description in Configure a Microsoft SQL Server source.
Unsupported source data types
DECIMAL or NUMERIC types with a scale greater than the precision are not supported.

Microsoft SQL Server Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Microsoft SQL Server source and a Google BigQuery target:
Microsoft SQL Server Source Data Type
Google BigQuery Target Data Type
bigint
int64
binary(size), 1 <= size <= 8000
bytes
bit
bool
char(size), 1 <= size <= 8000
string
date
date
datetime
datetime
datetime2(7)
string
datetime2(precision), 0 <= p <= 6
datetime
datetimeoffset(7)
string
datetimeoffset(precision), 0 <= p <= 6
timestamp
decimal(1,1)
numeric
decimal(10,10)
bignumeric
decimal(11,s), 10 <= s <= 11
bignumeric
decimal(12,s), 10 <= s <= 12
bignumeric
decimal(13,s), 10 <= s <= 13
bignumeric
decimal(14,s), 10 <= s <= 14
bignumeric
decimal(15,s), 10 <= s <= 15
bignumeric
decimal(16,s), 10 <= s <= 16
bignumeric
decimal(17,s), 10 <= s <= 17
bignumeric
decimal(18,s), 10 <= s <= 18
bignumeric
decimal(19,s), 10 <= s <= 19
bignumeric
decimal(2,s), 1 <= s <= 2
numeric
decimal(20,s), 10 <= s <= 20
bignumeric
decimal(21,s), 10 <= s <= 21
bignumeric
decimal(22,s), 10 <= s <= 22
bignumeric
decimal(23,s), 10 <= s <= 23
bignumeric
decimal(24,s), 10 <= s <= 24
bignumeric
decimal(25,s), 10 <= s <= 25
bignumeric
decimal(26,s), 10 <= s <= 26
bignumeric
decimal(27,s), 10 <= s <= 27
bignumeric
decimal(28,s), 10 <= s <= 28
bignumeric
decimal(3,s), 1 <= s <= 3
numeric
decimal(38,s), 10 <= s <= 38
bignumeric
decimal(4,s), 1 <= s <= 4
numeric
decimal(5,s), 1 <= s <= 5
numeric
decimal(6,s), 1 <= s <= 6
numeric
decimal(7,s), 1 <= s <= 7
numeric
decimal(8,s), 1 <= s <= 8
numeric
decimal(p,0), 1 <= p <= 18
int64
decimal(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
decimal(p,s), 29 <= p <= 30, 0 <= s <= 29
bignumeric
decimal(p,s), 30 <= p <= 31, 0 <= s <= 30
bignumeric
decimal(p,s), 31 <= p <= 32, 0 <= s <= 31
bignumeric
decimal(p,s), 32 <= p <= 33, 0 <= s <= 32
bignumeric
decimal(p,s), 33 <= p <= 34, 0 <= s <= 33
bignumeric
decimal(p,s), 34 <= p <= 35, 0 <= s <= 34
bignumeric
decimal(p,s), 35 <= p <= 36, 0 <= s <= 35
bignumeric
decimal(p,s), 36 <= p <= 37, 0 <= s <= 36
bignumeric
decimal(p,s), 37 <= p <= 38, 0 <= s <= 37
bignumeric
decimal(p,s), 9 <= p <= 38, 1 <= s <= 9
numeric
float
float64
geography
bytes
geometry
bytes
hierarchyid
bytes
image
bytes
int
int64
money
numeric
nchar(size), 1 <= size <= 4000
string
ntext
string
numeric(1,1)
numeric
numeric(10,10)
bignumeric
numeric(11,s), 10 <= s <= 11
bignumeric
numeric(12,s), 10 <= s <= 12
bignumeric
numeric(13,s), 10 <= s <= 13
bignumeric
numeric(14,s), 10 <= s <= 14
bignumeric
numeric(15,s), 10 <= s <= 15
bignumeric
numeric(16,s), 10 <= s <= 16
bignumeric
numeric(17,s), 10 <= s <= 17
bignumeric
numeric(18,s), 10 <= s <= 18
bignumeric
numeric(19,s), 10 <= s <= 19
bignumeric
numeric(2,s), 1 <= s <= 2
numeric
numeric(20,s), 10 <= s <= 20
bignumeric
numeric(21,s), 10 <= s <= 21
bignumeric
numeric(22,s), 10 <= s <= 22
bignumeric
numeric(23,s), 10 <= s <= 23
bignumeric
numeric(24,s), 10 <= s <= 24
bignumeric
numeric(25,s), 10 <= s <= 25
bignumeric
numeric(26,s), 10 <= s <= 26
bignumeric
numeric(27,s), 10 <= s <= 27
bignumeric
numeric(28,s), 10 <= s <= 28
bignumeric
numeric(3,s), 1 <= s <= 3
numeric
numeric(38,s), 10 <= s <= 38
bignumeric
numeric(4,s), 1 <= s <= 4
numeric
numeric(5,s), 1 <= s <= 5
numeric
numeric(6,s), 1 <= s <= 6
numeric
numeric(7,s), 1 <= s <= 7
numeric
numeric(8,s), 1 <= s <= 8
numeric
numeric(p,0), 1 <= p <= 18
int64
numeric(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
numeric(p,s), 29 <= p <= 30, 0 <= s <= 29
bignumeric
numeric(p,s), 30 <= p <= 31, 0 <= s <= 30
bignumeric
numeric(p,s), 31 <= p <= 32, 0 <= s <= 31
bignumeric
numeric(p,s), 32 <= p <= 33, 0 <= s <= 32
bignumeric
numeric(p,s), 33 <= p <= 34, 0 <= s <= 33
bignumeric
numeric(p,s), 34 <= p <= 35, 0 <= s <= 34
bignumeric
numeric(p,s), 35 <= p <= 36, 0 <= s <= 35
bignumeric
numeric(p,s), 36 <= p <= 37, 0 <= s <= 36
bignumeric
numeric(p,s), 37 <= p <= 38, 0 <= s <= 37
bignumeric
numeric(p,s), 9 <= p <= 38, 1 <= s <= 9
numeric
nvarchar(size), 1 <= size <= 4000
string
real
float64
smalldatetime
datetime
smallint
int64
smallmoney
numeric
sql_variant
bytes
text
string
time(7)
string
time(precision), 0 <= p <= 6
time
timestamp(8)
bytes
tinyint
int64
uniqueidentifier
string
varbinary(size), 1 <= size <= 8000
bytes
varchar(size), 1 <= size <= 8000
string
xml
string
LOB limitations
Database ingestion and replication initial load jobs can replicate data from SQL Server GEOGRAPHY, GEOMETRY, IMAGE, NTEXT, NVARCHAR(MAX), TEXT, VARBINARY(MAX), VARCHAR(MAX), and XML columns to Google BigQuery targets. LOB data might be truncated before being written to the target. For all of the LOB data types, the truncation point is 8388608 bytes. For more information, see the "Include LOBs" description in Configure a Microsoft SQL Server source.
Unsupported source data types
None.

Microsoft SQL Server Source and a Target That Uses the Parquet Output Format

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Microsoft SQL Server source and an Amazon S3, Google Cloud Storage, Microsoft Azure Data Lake Storage Gen2, or Microsoft Fabric OneLake target that uses the Parquet output format:
Microsoft SQL Server Source Data Type
Parquet Data Type
bigint
init64
binary
byte array
bit
int32
char
string
date
string
datetime
string
datetime2
string
datetimeoffset
string
decimal
string
float
string
geography
byte array
geometry
byte array
hierarchyid
byte array
image
byte array
int
int32
money
string
nchar
string
ntext
string
numeric
string
nvarchar
string
real
string
smalldatetime
string
smallint
int32
smallmoney
string
sql_variant
byte array (initial load)
string (incremental load)
text
string
time
string
timestamp
binary
tinyint
int32
uniqueidentifier
string
varbinary
byte array
varchar
string
xml
string

Microsoft SQL Server or Azure SQL Database Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Microsoft SQL Server or Azure SQL Database source and a Microsoft Azure Synapse Analytics target:
Microsoft SQL Server or Azure SQL Database Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
bigint
bigint
binary(size), 1 <= size <= 8000
binary(size), 1 <= size <= 8000
bit
bit
char(size), 1 <= size <= 8000
char(size), 1 <= size <= 8000
date
date
datetime
datetime2(3)
datetime2(precision), 0 <= p <= 7
datetime2(precision), 0 <= p <= 7
datetimeoffset(precision), 0 <= p <= 7
datetimeoffset(precision), 0 <= p <= 7
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
float
float
geography
varbinary(max)
geometry
varbinary(max)
hierarchyid
varbinary(892)
image
varbinary(max)
int
int
money
money
nchar(size), 1 <= size <= 4000
nchar(size), 1 <= size <= 4000
ntext
nvarchar(max)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
nvarchar(size), 1 <= size <= 4000
nvarchar(size), 1 <= size <= 4000
real
real
smalldatetime
datetime2(0)
smallint
smallint
smallmoney
smallmoney
sql_variant
varbinary(max)
text
varchar(max)
time(precision), 0 <= p <= 7
time(precision), 0 <= p <= 7
timestamp(8)
varbinary(8)
tinyint
tinyint
uniqueidentifier
uniqueidentifier
varbinary(size), 1 <= size <= 8000
varbinary(size), 1 <= size <= 8000
varchar(size), 1 <= size <= 8000
varchar(size), 1 <= size <= 8000
xml
varchar(max)
LOB limitations
Database ingestion and replication initial load jobs can replicate data from SQL Server GEOGRAPHY, GEOMETRY, IMAGE, NTEXT, NVARCHAR(MAX), TEXT, VARBINARY(MAX), VARCHAR(MAX), and XML columns to Azure Synapse Analytics targets. LOB data might be truncated before being written to the target. The truncation point depends on the data type and target type. For initial load jobs with an Azure Synapse Analytics target, GEOGRAPHY, GEOMETRY, IMAGE and VARBINARY(MAX) data is truncated to 1000000 bytes, and NTEXT, NVARCHAR(MAX), TEXT, VARCHAR(MAX), and XML data is truncated to 500000 bytes. For more information, see the "Include LOBs" description in Configure a Microsoft SQL Server source.
Unsupported source data types
None.

Microsoft SQL Server Source and Microsoft SQL Server Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Microsoft SQL Server source and a Microsoft SQL Server target:
SQL Server Source Data Type
SQL Server Target Data Type
bigint
bigint
binary
varbinary
bit
bit
char
varchar
date
date
datetime
datetime
datetime2
datetime2
datetimeoffset
datetimeoffset
decimal
decimal
float
float
geography
geography
geometry
geometry
hierarchyid
hierarchyid
image
image
int
int
money
money
nchar
nvarchar
ntext
ntext
numeric
numeric
nvarchar
nvarchar
real
real
smalldatetime
smalldatetime
smallint
smallint
smallmoney
smallmoney
sql_variant
sql_variant
text
text
time
time
timestamp
varbinary
tinyint
tinyint
uniqueidentifier
uniqueidentifier
varbinary
varbinary
varchar
varchar
xml
xml
Sql_variant target data type
Database ingestion and replication initial load jobs that have a SQL Server source and a SQL Server target and include a sql_variant source column convert the sql_variant data to hexadecimal format on the target. To convert data from hexadecimal format to varbinary format, run the following query:
SELECT <column_name>, CONVERT(varbinary,<column_name>) from <table_name>;
Replace <column_name> and <table_name> with the actual target column and table names.
LOB limitations
Database ingestion and replication initial load and incremental load jobs can replicate data from SQL Server GEOGRAPHY, GEOMETRY, IMAGE, NTEXT, NVARCHAR(MAX), TEXT, VARBINARY(MAX), VARCHAR(MAX), and XML columns to SQL Server targets. LOB data might be truncated before being written to the target. The truncation point depends on the data type and target type. For initial load jobs with a SQL Server target, GEOGRAPHY, GEOMETRY, IMAGE, TEXT, VARBINARY(MAX), and VARCHAR(MAX) data is truncated to 16777216 bytes, NTEXT and NVARCHAR(MAX) data to 33554432 bytes , and XML data to 33554442 bytes.
Unsupported source data types
None.

Microsoft SQL Server Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Microsoft SQL Server source and an Oracle target:
Microsoft SQL Server Source Data Type
Oracle Target Data Type
bigint
number(19)
binary(size), 1 <= size <= 2000
raw(size), 1 <= size <= 2000
binary(size), 2001 <= size <= 8000
blob
bit
char(1 char)
char(size), 1 <= size <= 2000
char(s char), 1 <= size <= 2000
char(size), 2001 <= size <= 4000
varchar2(s char), 2001 <= size <= 4000
char(size), 4001 <= size <= 8000
clob
date
date
datetime
timestamp(3)
datetime2(0)
date
datetime2(precision), 1 <= p <= 7
timestamp(precision), 1 <= p <= 7
datetimeoffset(precision), 0 <= p <= 7
timestamp(precision) with time zone, 0 <= p <= 7
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
number(p,s), 1 <= p <= 38, 0 <= s <= 38
float
binary_double
geography
blob
geometry
blob
hierarchyid
blob
image
blob
int
number(10)
money
number(19,4)
nchar(size), 1 <= size <= 1000
nchar(s char), 1 <= size <= 1000
nchar(size), 1001 <= size <= 2000
nvarchar2(s char), 1001 <=size <= 2000
nchar(size), 2001 <= size <= 4000
nclob
ntext
nclob
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
number(p,s), 1 <= p <= 38, 0 <= s <= 38
nvarchar(size), 1 <= size <= 2000
nvarchar2(s char), 1 <= size <= 2000
nvarchar(size), 2001 <= size <= 4000
nclob
real
binary_float
smalldatetime
date
smallint
number(5)
smallmoney
number(10,4)
sql_variant
blob
text
clob
time(precision), 0 <= p <= 7
timestamp(precision), 0 <= p <= 7
timestamp(8)
raw(8)
tinyint
number(3)
uniqueidentifier
char(36 char)
varbinary(size), 1 <= size <= 2000
raw(size), 1 <= size <= 2000
varbinary(size), 2001 <= size <= 8000
blob
varchar(size), 1 <= size <= 4000
varchar2(s char), 1 <= size <= 4000
varchar(size), 4001 <= size <= 8000
clob
xml
clob
LOB limitations
Database ingestion and replication initial load jobs can replicate data from SQL Server GEOGRAPHY, GEOMETRY, IMAGE, NTEXT, NVARCHAR(MAX), TEXT, VARBINARY(MAX), VARCHAR(MAX), and XML columns to Oracle targets. LOB data might be truncated before being written to the target. For all of the LOB data types, the truncation point is 16777216 bytes. For more information, see the "Include LOBs" description in Configure a Microsoft SQL Server source.
Unsupported source data types
None.

Microsoft SQL Server Source and PostgreSQL Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Microsoft SQL Server source and a PostgreSQL target:
Microsoft SQL Server Source Data Type
PostgreSQL Target Data Type
bigint
bigint
binary(size), 1 <= size <= 8000
bytea
bit
boolean
char(size), 1 <= size <= 8000
character varying(size), 1 <= size <= 8000
date
date
datetime
timestamp(3)
datetime2(precision), 0 <= p <= 6
timestamp(precision), 0 <= p <= 6
datetime2(7)
timestamp(6)
datetimeoffset(precision), 0 <= p <= 6
timestamptz(precision), 0 <= p <= 6
datetimeoffset(7)
timestamptz(6)
decimal(p,s), 1 <= p <= 38, 1 <= s <= 38
numeric(p,s), 1 <= p <= 38, 1 <= s <= 38
decimal(p,s), 1 <= p <= 38, s = 0
numeric(p), 1 <= p <= 38
float
double precision
geography
bytea
geometry
bytea
hierarchyid
bytea
image
bytea
int
integer
money
decimal(19,4)
nchar(size), 1 <= size <= 4000
character varying(size), 2 <= size <= 8000
ntext
text
numeric(p,s), 1 <= p <= 38, s = 0)
numeric(p), 1 <= p <= 38
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
number(p,s), 1 <= p <= 38, 0 <= s <= 38
nvarchar(size), 1 <= size <= 4000
character varying(size), 2 <= size <= 8000
real
real
smalldatetime
timestamp(0)
smallint
smallint
smallmoney
decimal(10,4)
sql_variant
bytea
text
text
time(precision), 0 <= p <= 6
time(precision), 0 <= p <= 6
time(7)
time(6)
timestamp(8)
bytea
tinyint
smallint
uniqueidentifier
uuid
varbinary(size), 1 <= size <= 8000
bytea
varchar(size), 1 <= size <= 8000
character varying (size), 1 <= size <= 8000
varchar(max)
text
xml
xml
LOB limitations
Database ingestion and replication initial load jobs can replicate data from SQL Server GEOGRAPHY, GEOMETRY, IMAGE, NTEXT, NVARCHAR(MAX), TEXT, VARBINARY(MAX), VARCHAR(MAX), and XML columns to PostgreSQL targets. LOB data might be truncated before being written to the target. For all of the LOB data types, the truncation point is 16777216 bytes. For more information, see the "Include LOBs" description in Configure a Microsoft SQL Server source.
Unsupported source data types
None.

Microsoft SQL Server or Azure SQL Database Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Microsoft SQL Server or Azure SQL Database source and a Snowflake target:
Microsoft SQL Server or Azure SQL Database Source Data Type
Snowflake Target Data Type
bigint
number(38,0)
binary(size), 1 <= size <= 8000
binary(size), 1 <= size <= 8000
bit
boolean
char(size), 1 <= size <= 8000
varchar(size), 1 <= size <= 8000
date
date
datetime
timestamp_ntz(3)
datetime2(precision), 0 <= p <= 7
timestamp_ntz(7)
datetimeoffset(precision), 0 <= p <= 7
timestamp_tz(precision), 0 <= p <= 7
decimal(38,38)
char(41)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37
number(p,s), 1 <= p <= 38, 0 <= s <= 37
float
float
geography
binary
geometry
binary
hierarchyid
binary(892)
image
binary
int
number(38,0)
money
number(19,4)
nchar(size), 1 <= size <= 4000
varchar(size), 4 <= size <= 16000
ntext
varchar
numeric(38,38)
char(41)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
number(p,s), 1 <= p <= 38, 0 <= s <= 37
nvarchar(size), 1 <= size <= 4000
varchar(size), 4 <= size <= 16000
real
float
smalldatetime
timestamp_ntz(0)
smallint
number(38,0)
smallmoney
number(10,4)
sql_variant
binary(8016)
text
varchar
time(precision), 0 <= p <= 7
time(precision), 0 <= p <= 7
timestamp(8)
binary(8)
tinyint
number(38,0)
uniqueidentifier
char(36)
varbinary(size), 1 <= size <= 8000
binary(size), 1 <= size <= 8000
varchar(size), 1 <= size <= 8000
varchar(size), 1 <= size <= 8000
xml
varchar
LOB limitations
Database ingestion and replication jobs that use any of the load types can replicate data from SQL Server GEOGRAPHY, GEOMETRY, IMAGE, NTEXT, NVARCHAR(MAX), TEXT, VARBINARY(MAX), VARCHAR(MAX), and XML columns to Snowflake targets. LOB data might be truncated before being written to the target. The truncation point depends on the data type and load type. For initial load jobs with a Snowflake target, GEOGRAPHY, GEOMETRY, IMAGE and VARBINARY(MAX) data is truncated to 8388608 bytes, and NTEXT, NVARCHAR(MAX), TEXT, VARCHAR(MAX), and XML data is truncated to 16777216 bytes. For incremental loads and combined loads, if LOB columns contain more than 8 KB of data, the data is truncated to 4000 bytes if stored inline or to approximately 8000 bytes if stored out-of-line. For more information, see the "Include LOBs" description in Configure a Microsoft SQL Server source.
Unsupported source data types
For incremental load jobs and combined initial and incremental load jobs that have a Snowflake target, Database Ingestion and Replication does not support the SQL Server hierarchyid data type. Database ingestion and replication jobs will propagate nulls for columns that have these data types.
If necessary, you can create custom data-type mappings when you define a database ingestion and replication task. For more information, see "Data Type Rules" in Configure a Snowflake Data Cloud target.

MongoDB Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MongoDB source and an Amazon Redshift target:
MongoDB Source Data Type
Amazon Redshift Target Data Type
document(2147483647)
super
id(32)
character varying(128)
Note: For a MongoDB source, Database Ingestion and Replication creates two columns on the target: an ID column, which provides an identifier similar to a primary key, and a Document column, which contains a JSON object containing an entire MongoDB record. Therefore, the mappings show the target data type associated with each of these columns.

MongoDB Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MongoDB source and a Databricks target:
MongoDB Source Data Type
Databricks Target Data Type
document(2147483647)
string
id(32)
string
Note: For a MongoDB source, Database Ingestion and Replication creates two columns on the target: an ID column, which provides an identifier similar to a primary key, and a Document column, which contains a JSON object containing an entire MongoDB record. Therefore, the mappings show the target data type associated with each of these columns.

MongoDB Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MongoDB source and a Google BigQuery target:
MongoDB Source Data Type
Google BigQuery Target Data Type
document(2147483647)
string
id(32)
string
Note: For a MongoDB source, Database Ingestion and Replication creates two columns on the target: an ID column, which provides an identifier similar to a primary key, and a Document column, which contains a JSON object containing an entire MongoDB record. Therefore, the mappings show the target data type associated with each of these columns.

MongoDB Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MongoDB source and a Microsoft Azure Synapse Analytics target:
MongoDB Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
document(2147483647)
nvarchar(max)
id(32)
nchar(32)
Note: For a MongoDB source, Database Ingestion and Replication creates two columns on the target: an ID column, which provides an identifier similar to a primary key, and a Document column, which contains a JSON object containing an entire MongoDB record. Therefore, the mappings show the target data type associated with each of these columns.

MongoDB Source and Microsoft SQL Server Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MongoDB source and a Microsoft SQL Server target:
MongoDB Source Data Type
Microsoft SQL Server Target Data Type
document(2147483647)
varchar(max)
id(32)
char(128)
Note: For a MongoDB source, Database Ingestion and Replication creates two columns on the target: an ID column, which provides an identifier similar to a primary key, and a Document column, which contains a JSON object containing an entire MongoDB record. Therefore, the mappings show the target data type associated with each of these columns.

MongoDB Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MongoDB source and an Oracle target:
MongoDB Source Column Type
Oracle Target Data Type
document(2147483647)
clob
id(32)
char(128)
Note: For a MongoDB source, Database Ingestion and Replication creates two columns on the target: an ID column, which provides an identifier similar to a primary key, and a Document column, which contains a JSON object containing an entire MongoDB record. Therefore, the mappings show the target data type associated with each of these columns.

MongoDB Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MongoDB source and a Snowflake target:
MongoDB Source Data Type
Snowflake Target Data Type
document(2147483647)
variant
id(32)
varchar(128)
Note: For a MongoDB source, Database Ingestion and Replication creates two columns on the target: an ID column, which provides an identifier similar to a primary key, and a Document column, which contains a JSON object containing an entire MongoDB record. Therefore, the mappings show the target data type associated with each of these columns.

MySQL Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MySQL source and an Amazon Redshift target:
MySQL Source Data Type
Amazon Redshift Target Data Type
bigint
bigint
bigint unsigned
numeric(20,0)
binary(size), 1 <= size <= 255
binary varying(size), 1 <= size <= 255
bit
binary varying(2)
bit(precision), 1 <= p <= 64
binary varying(size), 1 <= size <= 8
blob
binary varying(65535)
char(size), 1 <= size <= 255
character varying(size), 3 <= size <= 765
date
date
datetime
timestamp without time zone
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
numeric(p,s), 1 <= p <= 38, 0 <= s <= 29
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29
character varying(size), 40 <= size <= 67
double
double precision
float
real
geomcollection
binary varying(1024000)
geometry
binary varying(1024000)
geometrycollection
binary varying(1024000)
int
integer
int unsigned
bigint
json
character varying(65535)
linestring
binary varying(1024000)
longblob
binary varying(1024000)
longtext
character varying(65535)
mediumblob
binary varying(1024000)
mediumint
integer
mediumint unsigned
integer
mediumtext
character varying(65535)
multilinestring
binary varying(1024000)
multipoint
binary varying(1024000)
multipolygon
binary varying(1024000)
numeric
numeric(10,0)
point
binary varying(1024000)
polygon
binary varying(1024000)
smallint
smallint
smallint unsigned
integer
text
character varying(65535)
time(precision), 0 <= p <= 6
character varying(size), 10 <= size <= 17
timestamp(precision), 0 <= p <= 6
timestamp without time zone
tinyblob
binary varying(255)
tinyint
smallint
tinyint unsigned
smallint
tinytext
character varying(255)
varbinary(size), 1 <= size <= 65535
binary varying(size), 1 <= size <= 65535
varchar(size), 1 <= size <= 21844
character varying(size), 3 <= size <= 65532
year
smallint
Unsupported source data types
Database Ingestion and Replication does not support the following MySQL data types:
If a database ingestion and replication task specifies a source schema that includes columns with the JSON data type, deployment of the task ignores the JSON columns and does not create corresponding columns on the target. For other unsupported data types, database ingestion and replication jobs propagate nulls, even though the data types appear in the default mappings.

MySQL Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MySQL source and a Databricks target:
MySQL Source Data Type
Databricks Target Data Type
bigint
long
bigint unsigned
decimal(20)
binary(size), 1 <= size <= 255
binary
bit(precision), 1 <= p <= 64
binary
blob
binary
char(size), 1 <= size <= 255
string
date
string
datetime
timestamp
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29
string
double
double
float
float
geomcollection
binary
geometry
binary
geometrycollection
binary
int
integer
int unsigned
long
json
string
linestring
binary
longblob
binary
longtext
string
mediumblob
binary
mediumint
integer
mediumint unsigned
integer
mediumtext
string
multilinestring
binary
multipoint
binary
multipolygon
binary
numeric
decimal
point
binary
polygon
binary
smallint
integer
smallint unsigned
integer
text
string
time(precision), 0 <= p <= 6
string
timestamp(precision), 0 <= p <= 6
timestamp
tinyblob
binary
tinyint
integer
tinyint unsigned
integer
tinytext
string
varbinary(size), 1 <= size <= 65535
binary
varchar(size), 1 <= size <= 21844
string
year
integer
Unsupported source data types
Database Ingestion and Replication does not support the following MySQL data types:
If a database ingestion and replication task specifies a source schema that includes columns with the JSON data type, deployment of the task ignores the JSON columns and does not create corresponding columns on the target. For other unsupported data types, database ingestion and replication jobs propagate nulls, even though the data types appear in the default mappings.

MySQL Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MySQL source and a Google BigQuery target:
MySQL Source Data Type
Google BigQuery Target Data Type
bigint
int64
bigint unsigned
bignumeric
binary(size), 1 <= size <= 255
bytes
bit(precision), 1 <= p <= 64
bytes
blob
bytes
char(size), 1 <= size <= 255
string
date
date
datetime
datetime
decimal(1,1)
numeric
decimal(10,10)
bignumeric
decimal(11,s), 10 <= s <= 11
bignumeric
decimal(12,s), 10 <= s <= 12
bignumeric
decimal(13,s), 10 <= s <= 13
bignumeric
decimal(14,s), 10 <= s <= 14
bignumeric
decimal(15,s), 10 <= s <= 15
bignumeric
decimal(16,s), 10 <= s <= 16
bignumeric
decimal(17,s), 10 <= s <= 17
bignumeric
decimal(18,s), 10 <= s <= 18
bignumeric
decimal(19,s), 10 <= s <= 19
bignumeric
decimal(2,s), 1 <= s <= 2
numeric
decimal(20,s), 10 <= s <= 20
bignumeric
decimal(21,s), 10 <= s <= 21
bignumeric
decimal(22,s), 10 <= s <= 22
bignumeric
decimal(23,s), 10 <= s <= 23
bignumeric
decimal(24,s), 10 <= s <= 24
bignumeric
decimal(25,s), 10 <= s <= 25
bignumeric
decimal(26,s), 10 <= s <= 26
bignumeric
decimal(27,s), 10 <= s <= 27
bignumeric
decimal(28,s), 10 <= s <= 28
bignumeric
decimal(3,s), 1 <= s <= 3
numeric
decimal(4,s), 1 <= s <= 4
numeric
decimal(40,0)
string
decimal(41,s), 0 <= s <= 1
string
decimal(42,s), 0 <= s <= 2
string
decimal(43,s), 0 <= s <= 3
string
decimal(44,s), 0 <= s <= 4
string
decimal(45,s), 0 <= s <= 5
string
decimal(46,s), 0 <= s <= 6
string
decimal(47,s), 0 <= s <= 7
string
decimal(48,s), 0 <= s <= 8
string
decimal(49,s), 0 <= s <= 9
string
decimal(5,s), 1 <= s <= 5
numeric
decimal(50,s), 0 <= s <= 10
string
decimal(51,s), 0 <= s <= 11
string
decimal(52,s), 0 <= s <= 12
string
decimal(53,s), 0 <= s <= 13
string
decimal(54,s), 0 <= s <= 14
string
decimal(55,s), 0 <= s <= 15
string
decimal(56,s), 0 <= s <= 16
string
decimal(57,s), 0 <= s <= 17
string
decimal(58,s), 0 <= s <= 18
string
decimal(59,s), 0 <= s <= 19
string
decimal(6,s), 1 <= s <= 6
numeric
decimal(60,s), 0 <= s <= 20
string
decimal(61,s), 0 <= s <= 21
string
decimal(62,s), 0 <= s <= 22
string
decimal(63,s), 0 <= s <= 23
string
decimal(64,s), 0 <= s <= 24
string
decimal(65,s), 0 <= s <= 25
string
decimal(7,s), 1 <= s <= 7
numeric
decimal(8,s), 1 <= s <= 8
numeric
decimal(p,0), 1 <= p <= 18
int64
decimal(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
decimal(p,s), 29 <= p <= 64, 0 <= s <= 29
bignumeric
decimal(p,s), 30 <= p <= 31, 0 <= s <= 29
bignumeric
decimal(p,s), 39 <= p <= 65, 21 <= s <= 29
bignumeric
decimal(p,s), 9 <= p <= 38, 1 <= s <= 9
numeric
double
float64
float
float64
geomcollection
bytes
geometry
bytes
geometrycollection
bytes
int
int64
int unsigned
int64
json
string
linestring
bytes
longblob
bytes
longtext
string
mediumblob
bytes
mediumint
int64
mediumint unsigned
int64
mediumtext
string
multilinestring
bytes
multipoint
bytes
multipolygon
bytes
numeric
int64
point
bytes
polygon
bytes
smallint
int64
smallint unsigned
int64
text
string
time(precision), 0 <= p <= 6
string
timestamp(precision), 0 <= p <= 6
datetime
tinyblob
bytes
tinyint
int64
tinyint unsigned
int64
tinytext
string
varbinary(size), 1 <= size <= 65535
bytes
varchar(size), 1 <= size <= 21844
string
year
int64
Unsupported source data types
Database Ingestion and Replication does not support the following MySQL data types:
If a database ingestion and replication task specifies a source schema that includes columns with the JSON data type, deployment of the task ignores the JSON columns and does not create corresponding columns on the target. For other unsupported data types, database ingestion and replication jobs propagate nulls, even though the data types appear in the default mappings.

MySQL Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MySQL source and a Microsoft Azure Synapse Analytics target:
MySQL Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
bigint
bigint
bigint unsigned
decimal(20)
binary(size), 1 <= size <= 255
binary(size), 1 <= size <= 255
bit
bit
bit(precision), 1 <= p <= 64
binary(size), 1 <= size <= 8
blob
varbinary(max)
char(size), 1 <= size <= 255
varchar(size), 4 <= size <= 1020
date
date
datetime
datetime2(0)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29
char(size), 40 <= size <= 67
double
float
float
real
geomcollection
varbinary(max)
geometry
varbinary(max)
geometrycollection
varbinary(max)
int
int
int unsigned
bigint
json
varchar(max)
linestring
varbinary(max)
longblob
varbinary(max)
longtext
varchar(max)
mediumblob
varbinary(max)
mediumint
int
mediumint unsigned
int
mediumtext
varchar(max)
multilinestring
varbinary(max)
multipoint
varbinary(max)
multipolygon
varbinary(max)
numeric
decimal(10)
point
varbinary(max)
polygon
varbinary(max)
smallint
smallint
smallint unsigned
int
text
varchar(max)
time(precision), 0 <= p <= 6
varchar(size), 10 <= size <= 17
timestamp(precision), 0 <= p <= 6
datetime2(precision), 0 <= p <= 6
tinyblob
binary(255)
tinyint
smallint
tinyint unsigned
smallint
tinytext
char(256)
varbinary(size), 1 <= size <= 65535
varbinary(size), 1 <= size <= max
varchar(size), 1 <= size <= 21844
varchar(size), 4 <= size <= max
year
smallint
Unsupported source data types
Database Ingestion and Replication does not support the following MySQL data types:
If a database ingestion and replication task specifies a source schema that includes columns with the JSON data type, deployment of the task ignores the JSON columns and does not create corresponding columns on the target. For other unsupported data types, database ingestion and replication jobs propagate nulls, even though the data types appear in the default mappings.

MySQL Source and Microsoft SQL Server Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MySQL source and a Microsoft SQL Server target:
MySQL Source Data Type
Microsoft SQL Server Target Data Type
bigint
bigint
bigint unsigned
decimal(20,0)
binary(size), 1 <= size <= 255
binary(size), 1 <= size <= 255
bit
bit
bit(precision), 1 <= p <= 64
binary(size), 1 <= size <= 8
blob
varbinary(max)
char(size), 1 <= size <= 255
varchar(size), 3 <= size <= 765
date
date
datetime
datetime2
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29
char(size), 40 <= size <= 67
double
float
float
real
geomcollection
binary(8000)
geometry
varbinary(max)
geometrycollection
varbinary(max)
int
int
int unsigned
bigint
json
varchar(max)
linestring
varbinary(max)
longblob
varbinary(max)
longtext
varchar(max)
mediumblob
varbinary(max)
mediumint
int
mediumint unsigned
int
mediumtext
varchar(max)
multilinestring
varbinary(max)
multipoint
varbinary(max)
multipolygon
varbinary(max)
numeric(10,0)
decimal(10,0)
point
varbinary(max)
polygon
varbinary(max)
smallint
smallint
smallint unsigned
int
text
varchar(max)
time(precision), 0 <= p <= 6
varchar(size), 10 <= size <= 17
timestamp(precision), 0 <= p <= 3
datetime2
timestamp(precision), 4 <= p <= 6
datetime2(precision), 4 <= p <= 6
tinyblob
binary(255)
tinyint
smallint
tinyint unsigned
tinyint
tinytext
varchar(255)
varbinary(size), 1 <= size <= 65535
varbinary(size), 1 <= size <= max
varchar(size), 1 <= size <= 21844
varchar(size), 3 <= size <= max
year
smallint
Unsupported source data types
Database Ingestion and Replication does not support the following MySQL data types:
If a database ingestion and replication task specifies a source schema that includes columns with the JSON data type, deployment of the task ignores the JSON columns and does not create corresponding columns on the target. For other unsupported data types, database ingestion and replication jobs propagate nulls, even though the data types appear in the default mappings.

MySQL Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MySQL source and an Oracle target:
MySQL Source Data Type
Oracle Target Data Type
bigint
number(19)
bigint unsigned
number(20)
binary(size), 1 <= size <= 255
raw(size), 1 <= size <= 255
bit(precision), 1 <= p <= 64
raw(size), 1 <= size <= 8
blob
blob
char(size), 1 <= size <= 255
varchar2(s char), 3 <= s <= 765
date
date
datetime
date
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
number(p,s), 1 <= p <= 38, 0 <= s <= 29
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29
char(s char), 40 <= s <= 67
double
binary_double
float
binary_float
geomcollection
blob
geometry
blob
geometrycollection
blob
int
number(10)
int unsigned
number(10)
json
clob
linestring
blob
longblob
blob
longtext
clob
mediumblob
blob
mediumint
number(7)
mediumint unsigned
number(8)
mediumtext
clob
multilinestring
blob
multipoint
blob
multipolygon
blob
numeric(10,0)
number(10)
point
blob
polygon
blob
smallint
number(5)
smallint unsigned
number(5)
text
clob
time(precision), 0 <= p <= 6
char(s char), 10 <= s <= 17
timestamp(precision), 0 <= p <= 6
timestamp(precision), 0 <= p <= 6
tinyblob
raw(255)
tinyint
number(3)
tinyint unsigned
number(3)
tinytext
varchar2(255 char)
varbinary(size), 1 <= size <= 2000
raw(size), 1 <= size <= 2000
varbinary(size), 2001 <= size <= 65535
long raw
varchar(size), 1 <= size <= 4000
varchar2(s char), 3 <= s <= 4000
varchar(size), 4001 <= size <= 21844
clob
year
number(4)
Unsupported source data types
Database Ingestion and Replication does not support the following MySQL data types:
If a database ingestion and replication task specifies a source schema that includes columns with the JSON data type, deployment of the task ignores the JSON columns and does not create corresponding columns on the target. For other unsupported data types, database ingestion and replication jobs propagate nulls, even though the data types appear in the default mappings.

MySQL Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MySQL source and a Snowflake target:
MySQL Source Data Type
Snowflake Target Data Type
bigint
number(19)
bigint unsigned
number(20)
binary(size), 1 <= size <= 255
binary(size), 1 <= size <= 255
bit(precision), 1 <= p <= 64
binary(size), 1 <= size <= 8
blob
binary(65535)
char(size), 1 <= size <= 255
varchar(size), 4 <= size <= 1020
date
date
datetime
timestamp_ntz(0)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
number(p,s), 1 <= p <= 38, 0 <= s <= 29
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29
char(size), 40 <= size <= 67
double
float
float
float
geomcollection
binary
geometry
binary
geometrycollection
binary
int
number(10)
int unsigned
number(10)
linestring
binary
longblob
binary
longtext
varchar
mediumblob
binary
mediumint
number(7)
mediumint unsigned
number(8)
mediumtext
varchar
multilinestring
binary
multipoint
binary
multipolygon
binary
numeric(10,0)
integer
point
binary
polygon
binary
smallint
number(5)
smallint unsigned
number(5)
text
varchar(87380)
time(precision), 0 <= p <= 6
varchar(size), 10 <= size <= 17
timestamp(precision), 0 <= p <= 6
timestamp_ntz(precision), 0 <= p <= 6
tinyblob
binary(255)
tinyint
number(3)
tinyint unsigned
number(3)
tinytext
varchar(340)
varbinary(size), 1 <= size <= 65535
binary(size), 1 <= size <= 65535
varchar(size), 1 <= size <= 21844
varchar(size), 4 <= size <= 87376
year
number(4)
Unsupported source data types
Database Ingestion and Replication does not support the following MySQL data types:
If a database ingestion and replication task specifies a source schema that includes columns with the JSON data type, deployment of the task ignores the JSON columns and does not create corresponding columns on the target. For other unsupported data types, database ingestion and replication jobs propagate nulls, even though the data types appear in the default mappings.

Netezza Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Netezza source and an Amazon Redshift target:
Netezza Source Data Type
Amazon Redshift Target Data Type
bigint
bigint
boolean
boolean
byteint
smallint
char(size), 1 <= size <= 4096
character(size), 1 <= size <= 4096
char(size), 4097 <= size <= 64000
character varying(size), 4097 <= size <= 64000
date
date
double
double precision
integer
integer
interval
character varying(55)
nchar(size), 1 <= size <= 16000
character varying(size), 4 <= size <= 64000
numeric(38,38)
character varying(41)
numeric(p), 1 <= p <= 38
numeric(p,0), 1 <= p <= 38
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37
nvarchar(size), 1 <= size <= 16000
character varying(size), 4 <= size <= 64000
real
real
smallint
smallint
st_geometry(p), 1 <= p <= 63001
binary varying(size), 1 <= size <= 63001
time
time without time zone
timestamp
timestamp without time zone
timetz
timetz
varbinary(size), 1 <= size <= 64000
binary varying(size), 1 <= size <= 64000
varchar(size), 1 <= size <= 64000
character varying(size), 1 <= size <= 64000
Unsupported source data types
Database Ingestion and Replication does not support the following Netezza data type:
Note: Even though this data type appears in the default mappings, database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have this data type.

Netezza Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Netezza source and a Databricks target:
Netezza Source Data Type
Databricks Target Data Type
bigint
long
boolean
boolean
byteint
integer
char(size), 1 <= size <= 64000
string
date
string
double
double
integer
integer
interval
string
nchar(size), 1 <= size <= 16000
string
numeric(p,s), 1 <= p <= 38, 1 <= s <= 38
decimal(p,s), 1 <= p <= 38, 1 <= s <= 38
nvarchar(size), 1 <= size <= 16000
string
real
float
smallint
integer
st_geometry(precision), 1 <= p <= 63001
binary
time
string
timestamp
timestamp
timetz
string
varbinary(size), 1 <= size <= 64000
binary
varchar(size), 1 <= size <= 64000
string
Unsupported source data types
Database Ingestion and Replication does not support the following Netezza data type:
Note: Even though this data type appears in the default mappings, database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have this data type.

Netezza Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Netezza source and a Google BigQuery target:
Netezza Source Data Type
Google BigQuery Target Data Type
bigint
int64
boolean
bool
byteint
int64
char(size), 1 <= size <= 64000
string
date
date
double
float64
integer
int64
interval
string
nchar(size), 1 <= size <= 16000
string
numeric(10,10)
bignumeric
numeric(11,s), 10 <= s <= 11
bignumeric
numeric(12,s), 10 <= s <= 12
bignumeric
numeric(13,s), 10 <= s <= 13
bignumeric
numeric(14,s), 10 <= s <= 14
bignumeric
numeric(15,s), 10 <= s <= 15
bignumeric
numeric(16,s), 10 <= s <= 16
bignumeric
numeric(17,s), 10 <= s <= 17
bignumeric
numeric(18,s), 10 <= s <= 18
bignumeric
numeric(19,s), 10 <= s <= 19
bignumeric
numeric(20,s), 10 <= s <= 20
bignumeric
numeric(21,s), 10 <= s <= 21
bignumeric
numeric(22,s), 10 <= s <= 22
bignumeric
numeric(23,s), 10 <= s <= 23
bignumeric
numeric(24,s), 10 <= s <= 24
bignumeric
numeric(25,s), 10 <= s <= 25
bignumeric
numeric(26,s), 10 <= s <= 26
bignumeric
numeric(27,s), 10 <= s <= 27
bignumeric
numeric(28,s), 10 <= s <= 28
bignumeric
numeric(29,s), 10 <= s <= 29
bignumeric
numeric(38,s), 10 <= s <= 38
bignumeric
numeric(precision), 1 <= p <= 17
int64
numeric(precision), 19 <= p <= 29
numeric
numeric(precision), 30 <= p <= 38
bignumeric
numeric(p,s), 1 <= p <= 38, 1 <= s <= 9
numeric
numeric(p,s), 30 <= p <= 31, 1 <= s <= 30
bignumeric
numeric(p,s), 31 <= p <= 32, 1 <= s <= 31
bignumeric
numeric(p,s), 32 <= p <= 33, 1 <= s <= 32
bignumeric
numeric(p,s), 33 <= p <= 34, 1 <= s <= 33
bignumeric
numeric(p,s), 34 <= p <= 35, 1 <= s <= 34
bignumeric
numeric(p,s), 35 <= p <= 36, 1 <= s <= 35
bignumeric
numeric(p,s), 36 <= p <= 37, 1 <= s <= 36
bignumeric
numeric(p,s), 37 <= p <= 38, 1 <= s <= 37
bignumeric
nvarchar(size), 1 <= size <= 16000
string
real
float64
smallint
int64
st_geometry(precision), 1 <= p <= 63001
bytes
time
time
timestamp
datetime
timetz
timestamp
varbinary(size), 1 <= size <= 64000
bytes
varchar(size), 1 <= size <= 64000
string
Unsupported source data types
Database Ingestion and Replication does not support the following Netezza data type:
Note: Even though this data type appears in the default mappings, database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have this data type.

Netezza Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Netezza source and a Microsoft Azure Synapse Analytics target:
Netezza Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
bigint
bigint
boolean
bit
byteint
smallint
char(size), 1 <= size <= 8000
char(size), 1 <= size <= 8000
char(size), 9000 <= size <= 64000
nvarchar(max)
date
date
double
float
integer
int
interval
varchar(55)
nchar(size), 1 <= size <= 3100
nchar(size), 1 <= size <= 3100
nchar(size), 4100 <= size <= 16000
nvarchar(max)
numeric(p,s), 1 <= p <= 38, 1 <= s <= 38
decimal(p,s), 1 <= p <= 38, 1 <= s <= 38
nvarchar(size), 1 <= size <= 16000
nvarchar(size), 1 <= size <= max
real
real
smallint
smallint
st_geometry(precision), 1 <= p <= 63001
varbinary(size), 1 <= size <= max
time
time(6)
timestamp
datetime2(6)
timetz
datetimeoffset(6)
varbinary(size), 1 <= size <= 64000
varbinary(size), 1 <= size <= max
varchar(size), 1 <= size <= 64000
varchar(size), 1 <= size <= max
Unsupported source data types
Database Ingestion and Replication does not support the following Netezza data type:
Note: Even though this data type appears in the default mappings, database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have this data type.

Netezza Source and Microsoft SQL Server Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Netezza source and a Microsoft SQL Server target:
Netezza Source Data Type
Microsoft SQL Server Target Data Type
bigint
bigint
boolean
bit
byteint
smallint
char(size), 1 <= size <= 64000
varchar(size), 1 <= size <= max
date
date
double
float
integer
int
interval
varchar(55)
nchar(size), 1 <= size <= 16000
nvarchar(size), 4 <= size <= max
numeric(p,s), 1 <= p <= 38, 1 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
nvarchar(size), 1 <= size <= 16000
nvarchar(size), 4 <= size <= max
real
real
smallint
smallint
st_geometry(precision), 1 <= p <= 63001
varbinary(size), 1 <= size <= max
time
time(6)
timestamp
datetime2(6)
timetz
datetimeoffset(6)
varbinary(size), 1 <= size <= 64000
varbinary(size), 1 <= size <= max
varchar(size), 1 <= size <= 64000
varchar(size), 1 <= size <= max
Unsupported source data types
Database Ingestion and Replication does not support the following Netezza data type:
Note: Even though this data type appears in the default mappings, database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have this data type.

Netezza Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Netezza source and an Oracle target:
Netezza Source Data Type
Oracle Target Data Type
bigint
number(19)
boolean
char(1 char)
byteint
number(3)
char(size), 1 <= size <= 3001
varchar2(s char), 1 <= s <= 3001
char(size), 4096 <= size <= 64000
clob
date
date
double
binary_double
integer
number(10)
interval
varchar2(55 char)
nchar(size), 1 <= size <= 901
nvarchar2(s char), 1 <= s <= 901
nchar(size), 1024 <= size <= 1100
char(2000 char)
nchar(size), 2100 <= size <= 16000
clob
numeric(p,s), 1 <= p <= 38, 1 <= s <= 38
number(p,s), 1 <= p <= 38, 1 <= s <= 38
nvarchar(1)
nvarchar2(1 char)
nvarchar(1001)
char(2000 char)
nvarchar(size), 2001 <= s <= 16000
clob
real
binary_float
smallint
number(5)
st_geometry(precision), 1 <= p <= 1001
raw(size), 1 <= size <= 1001
st_geometry(precision), 2001 <= p <= 63001
blob
time
timestamp(6)
timestamp
timestamp(6)
timetz
timestamp(precision) with time zone, 6 <= p <= null
varbinary(size), 1 <= size <= 1001
raw(size), 1 <= size <= 1001
varbinary(size), 2001 <= size <= 64000
blob
varchar(size), 1 <= size <= 3001
varchar2(s char), 1 <= s <= 3001
varchar(size), 4001 <= size <= 64000
clob
Unsupported source data types
Database Ingestion and Replication does not support the following Netezza data type:
Note: Even though this data type appears in the default mappings, database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have this data type.

Netezza Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Netezza source and a Snowflake target:
Netezza Source Data Type
Snowflake Target Data Type
bigint
integer
boolean
boolean
byteint
integer
char(size), 1 <= size <= 64000
char(size), 1 <= size <= 64000
date
date
double
float
integer
integer
interval
varchar(55)
nchar(size), 1 <= size <= 16000
char(size), 4 <= size <= 64000
numeric(38,38)
char(41)
numeric(precision), 1 <= p <= 38
integer
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37
number(p,s), 1 <= p <= 38, 1 <= s <= 37
nvarchar(size), 1 <= size <= 16000
varchar(size), 4 <= size <= 64000
real
float
smallint
integer
st_geometry(precision), 1 <= p <= 63001
binary(size), 1 <= size <= 63001
time
time(6)
timestamp
timestamp_ntz(6)
timetz
timestamp_tz(6)
varbinary(size), 1 <= size <= 64000
binary(size), 1 <= size <= 64000
varchar(size), 1 <= size <= 64000
varchar(size), 1 <= size <= 64000
Unsupported source data types
Database Ingestion and Replication does not support the following Netezza data type:
Note: Even though this data type appears in the default mappings, database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have this data type.

Oracle Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an Oracle source and an Amazon Redshift target:
Oracle Source Data Type
Amazon Redshift Target Data Type
binary_double
float8
binary_float
float4
blob
binary varying(1024000)
char(s byte), 1 <= size <= 2000
character varying(size), 4 <= size <= 2000
char(s char), 1 <= size <= 2000
character varying(size), 4 <= size <= 8000
clob
character varying(65535)
date
timestamp without time zone
float(precision), 1 <= p <= 126
character varying(255)
integer
character varying(255)
long raw
varbyte
long(2147483648 byte)
character varying(65535)
nchar(s char), 1 <= size <= 2000
character varying(size), 4 <= size <= 8000
nclob
character varying(65535)
number
number
number(*,s), -84 <= s <= 127
character varying(255)
number(38,s), 0 <= s <= 37
numeric(38,s), 0 <= s <= 37
number(p,s), 1 <= p <= 38, -37 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
number(p,s), 1 <= p <= 38, -84 <= s <= 127
character varying(size), 40 <= size <= 130
number(p,s), 10 <= p <= 38, -28 <= s <= 37
numeric(p,s), 10 <= p <= 38, 0 <= s <= 37
number(p,s), 11 <= p <= 38, -27 <= s <= 37
numeric(p,s), 11 <= p <= 38, 0 <= s <= 37
number(p,s), 12 <= p <= 38, -26 <= s <= 37
numeric(p,s), 12 <= p <= 38, 0 <= s <= 37
number(p,s), 13 <= p <= 38, -25 <= s <= 37
numeric(p,s), 13 <= p <= 38, 0 <= s <= 37
number(p,s), 14 <= p <= 38, -24 <= s <= 37
numeric(p,s), 14 <= p <= 38, 0 <= s <= 37
number(p,s), 15 <= p <= 38, -23 <= s <= 37
numeric(p,s), 15 <= p <= 38, 0 <= s <= 37
number(p,s), 16 <= p <= 38, -22 <= s <= 37
numeric(p,s), 16 <= p <= 38, 0 <= s <= 37
number(p,s), 17 <= p <= 38, -21 <= s <= 37
numeric(p,s), 17 <= p <= 38, 0 <= s <= 37
number(p,s), 18 <= p <= 38, -20 <= s <= 37
numeric(p,s), 18 <= p <= 38, 0 <= s <= 37
number(p,s), 19 <= p <= 38, -19 <= s <= 37
numeric(p,s), 20 <= p <= 38, 0 <= s <= 37
number(p,s), 2 <= p <= 38, -36 <= s <= 37
numeric(p,s), 2 <= p <= 38, 0 <= s <= 37
number(p,s), 21 <= p <= 38, -17 <= s <= 37
numeric(p,s), 21 <= p <= 38, 0 <= s <= 37
number(p,s), 22 <= p <= 38, -16 <= s <= 37
numeric(p,s), 22 <= p <= 38, 0 <= s <= 37
number(p,s), 23 <= p <= 38, -15 <= s <= 37
numeric(p,s), 23 <= p <= 38, 0 <= s <= 37
number(p,s), 24 <= p <= 38, -14 <= s <= 37
numeric(p,s), 24 <= p <= 38, 0 <= s <= 37
number(p,s), 25 <= p <= 38, -13 <= s <= 37
numeric(p,s), 25 <= p <= 38, 0 <= s <= 37
number(p,s), 26 <= p <= 38, -12 <= s <= 37
numeric(p,s), 26 <= p <= 38, 0 <= s <= 37
number(p,s), 27 <= p <= 38, -11 <= s <= 37
numeric(p,s), 27 <= p <= 38, 0 <= s <= 37
number(p,s), 28 <= p <= 38, -10 <= s <= 37
numeric(p,s), 28 <= p <= 38, 0 <= s <= 37
number(p,s), 29 <= p <= 38, -9 <= s <= 37
numeric(p,s), 29 <= p <= 38, 0 <= s <= 37
number(p,s), 3 <= p <= 38, -35 <= s <= 37
numeric(p,s), 3 <= p <= 38, 0 <= s <= 37
number(p,s), 30 <= p <= 38, -8 <= s <= 37
numeric(p,s), 30 <= p <= 38, 0 <= s <= 37
number(p,s), 31 <= p <= 38, -7 <= s <= 37
numeric(p,s), 31 <= p <= 38, 0 <= s <= 37
number(p,s), 32 <= p <= 38, -6 <= s <= 37
numeric(p,s), 32 <= p <= 38, 0 <= s <= 37
number(p,s), 33 <= p <= 38, -5 <= s <= 37
numeric(p,s), 33 <= p <= 38, 0 <= s <= 37
number(p,s), 34 <= p <= 38, -4 <= s <= 37
numeric(p,s), 34 <= p <= 38, 0 <= s <= 37
number(p,s), 35 <= p <= 38, -3 <= s <= 37
numeric(p,s), 35 <= p <= 38, 0 <= s <= 37
number(p,s), 36 <= p <= 38, -2 <= s <= 37
numeric(p,s), 36 <= p <= 38, 0 <= s <= 37
number(p,s), 37 <= p <= 38, -1 <= s <= 37
numeric(p,s), 37 <= p <= 38, 0 <= s <= 37
number(p,s), 4 <= p <= 38, -34 <= s <= 37
numeric(p,s), 4 <= p <= 38, 0 <= s <= 37
number(p,s), 5 <= p <= 38, -33 <= s <= 37
numeric(p,s), 5 <= p <= 38, 0 <= s <= 37
number(p,s), 6 <= p <= 38, -32 <= s <= 37
numeric(p,s), 6 <= p <= 38, 0 <= s <= 37
number(p,s), 7 <= p <= 38, -31 <= s <= 37
numeric(p,s), 7 <= p <= 38, 0 <= s <= 37
number(p,s), 8 <= p <= 38, -30 <= s <= 37
numeric(p,s), 8 <= p <= 38, 0 <= s <= 37
number(p,s), 9 <= p <= 38, -29 <= s <= 37
numeric(p,s), 9 <= p <= 38, 0 <= s <= 37
nvarchar2(s char), 1 <= size <= 4000
character varying(size), 4 <= size <= 16000
raw(size), 1 <= size <= 2000
varbyte
rowid
character varying(18)
timestamp(precision) with time zone, 0 <= p <= 6
timestamp with time zone
timestamp(precision) with time zone, 7 <= p <= 9
character varying(29)
timestamp(precision), 1 <= p <= 6
timestamp without time zone
timestamp(precision), 7 <= p <= 9
character varying(size), 27 <= s <= 29
varchar2(s byte), 1 <= size <= 4000
character varying(size), 4 <= size <= 4000
varchar2(s char), 1 <= size <= 4000
character varying(size), 4 <= size <= 16000
xml
character varying(65535)
LOB limitations
Database ingestion and replication initial load, incremental load, and combined load jobs can replicate data from Oracle BLOB, CLOB, LONG, LONG RAW, NCLOB, and XML columns to Amazon Redshift targets. LOB column data might be truncated on the target. The truncation point depends on the data type and target type. For more information, see the "Include LOBs" description in Configure an Oracle source.
Unsupported source data types
Database Ingestion and Replication does not support the following Oracle source data types:
Source columns that have unsupported data types are excluded from the target definition.

Oracle Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Oracle source and a Databricks target:
Oracle Source Data Type
Databricks Target Data Type
binary_double
double
binary_float
float
blob
binary
char(s byte), 1 <= size <= 2000
string
char(s char), 1 <= size <= 2000
string
clob
string
date
timestamp
float(precision), 1 <= p <= 126
string
integer
string
long raw
binary
long(2147483648 byte)
string
nchar(s char), 1 <= size <= 2000
string
nclob
string
number
string
number(*,s), -84 <= s <= 127
string
number(p,s), 1 <= p <= 38, -37 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
number(p,s), 1 <= p <= 38, -84 <= s <= 127
string
nvarchar2(s char), 1 <= size <= 4000
string
raw(size), 1 <= size <= 2000
binary
rowid
string
timestamp(precision) with time zone, 0 <= p <= 6
timestamp
timestamp(precision) with time zone, 7 <= p <= 9
string
timestamp(precision), 1 <= p <= 6
timestamp
timestamp(precision), 7 <= p <= 9
string
varchar2(s byte), 1 <= size <= 4000
string
varchar2(s char), 1 <= size <= 4000
string
xml
string
LOB limitations
Database ingestion and replication initial load, incremental load, and combined load jobs can replicate data from Oracle BLOB, CLOB, LONG, LONG RAW, NCLOB, and XML columns to Databricks targets. LOB column data might be truncated on the target. For all of the Oracle LOB data types replicated to this target type, the truncation point is 16777216 bytes. For more information, see the "Include LOBs" description in Configure an Oracle source.
Unsupported source data types
Database Ingestion and Replication does not support the following Oracle source data types:
Source columns that have unsupported data types are excluded from the target definition.
If necessary, you can create custom data-type mappings when you define a database ingestion and replication task. For more information, see "Data Type Rules" in Configure a Databricks target.

Oracle Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Oracle source and a Google BigQuery target:
Oracle Source Data Type
Google BigQuery Target Data Type
binary_double
float64
binary_float
float64
blob
bytes
char(s byte), 1 <= size <= 2000
string
char(s char), 1 <= size <= 2000
string
clob
string
date
datetime
float(precision), 1 <= p <= 126
string
integer
string
long raw
bytes
long(2147483648 byte)
string
nchar(s char), 1 <= size <= 2000
string
nclob
string
number
string
number(*,s), -84 <= s <= 127
string
number(1,-38)
bignumeric
number(1,s), -37 <= s <= -29
bignumeric
number(1,s), -84 <= s <= -39
string
number(10,-29)
bignumeric
number(11,-28)
bignumeric
number(12,-27)
bignumeric
number(13,-26)
bignumeric
number(14,-25)
bignumeric
number(15,-24)
bignumeric
number(16,-23)
bignumeric
number(17,-22)
bignumeric
number(18,-21)
bignumeric
number(19,-20)
bignumeric
number(2,-37)
bignumeric
number(20,-19)
bignumeric
number(21,-18)
bignumeric
number(22,-17)
bignumeric
number(23,-16)
bignumeric
number(24,-15)
bignumeric
number(25,-14)
bignumeric
number(26,-13)
bignumeric
number(27,-12)
bignumeric
number(28,-11)
bignumeric
number(29,-10)
bignumeric
number(3,-36)
bignumeric
number(30,-9)
bignumeric
number(31,-8)
bignumeric
number(32,-7)
bignumeric
number(33,-6)
bignumeric
number(34,-5)
bignumeric
number(35,-4)
bignumeric
number(36,-3)
bignumeric
number(37,-2)
bignumeric
number(38,-1)
bignumeric
number(38,s), 10 <= s <= 38
bignumeric
number(4,-35)
bignumeric
number(5,-34)
bignumeric
number(6,-33)
bignumeric
number(7,-32)
bignumeric
number(8,-31)
bignumeric
number(9,-30)
bignumeric
number(p,s), 1 <= p <= 38, -28 <= s <= 9
numeric
number(p,s), 1 <= p <= 38, -36 <= s <= 38
bignumeric
number(p,s), 1 <= p <= 38, -84 <= s <= 127
string
number(p,s), 2 <= p <= 3, -35 <= s <= 38
bignumeric
number(p,s), 2 <= p <= 3, -84 <= s <= 127
string
nvarchar2(s char), 1 <= s <= 4000
string
raw(size), 1 <= size <= 2000
bytes
rowid
string
timestamp(precision) with time zone, 0 <= p <= 6
timestamp
timestamp(precision) with time zone, 7 <= p <= 9
string
timestamp(precision), 1 <= p <= 6
datetime
timestamp(precision), 7 <= p <= 9
string
varchar2(s byte), 1 <= size <= 4000
string
varchar2(s char), 1 <= size <= 4000
string
xml
string
LOB limitations
Database ingestion and replication initial load, incremental load, and combined load jobs can replicate data from Oracle BLOB, CLOB, LONG, LONG RAW, NCLOB, and XML columns to Google BigQuery targets. LOB column data might be truncated on the target. For all of the Oracle LOB data types, the truncation point is 8388608 bytes. For more information, see the "Include LOBs" description in Configure an Oracle source.
Unsupported source data types
Database Ingestion and Replication does not support the following Oracle source data types:
Source columns that have unsupported data types are excluded from the target definition.
If necessary, you can create custom data-type mappings when you define a database ingestion and replication task. For more information, see "Data Type Rules" in Configure a Google BigQuery target.

Oracle Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an Oracle source and a Microsoft Azure Synapse Analytics target:
Oracle Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
binary_double
float
binary_float
real
blob
varbinary(max)
char(s byte), 1 <= size <= 2000
varchar(size), 4 <= size <= 2000
char(s char), 1 <= size <= 2000
varchar(size), 4 <= size <= 8000
clob
varchar(max)
date
datetime2(0)
float(precision), 1 <= p <= 126
varchar(255)
integer
varchar(255)
long raw
varbinary(max)
long(2147483648 byte)
varchar(max)
nchar(s char), 1 <= size <= 2000
nchar(size), 1 <= size <= 2000
nclob
nvarchar(max)
number
varchar(255)
number(*,s), -84 <= s <= 127
varchar(255)
number(p,s), 1 <= p <= 38, -37 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
number(p,s), 1 <= p <= 38, -84 <= s <= 127
varchar(size), 40 <= size <= 130
nvarchar2(s char), 1 <= s <= 4000
nvarchar(size), 1 <= size <= 4000
raw(size), 1 <= s <= 2000
varbinary(size), 1 <= size <= 2000
rowid
varchar(18)
timestamp(precision) with time zone, 0 <= p <= 7
datetimeoffset(precision), 0 <= p <= 7
timestamp(precision) with time zone, 8 <= p <= 9
char(size), 68 <= size <= 69
timestamp(precision), 1 <= p <= 7
datetime2(precision), 1 <= p <= 7
timestamp(precision), 8 <= p <= 9
char(size), 28 <= size <= 29
varchar2(s byte), 1 <= size <= 4000
varchar(size), 4 <= size <= 4000
varchar2(s char), 1 <= size <= 4000
varchar(size), 4 <= size <= max
xml
varchar(max)
LOB limitations
Database ingestion and replication initial load, incremental load, and combined load jobs can replicate data from Oracle BLOB, CLOB, LONG, LONG RAW, NCLOB, and XML columns to Microsoft Azure Synapse Analytics targets. LOB column data might be truncated on the target. For an Azure Synapse Analytics target, BLOB and LONG RAW data is truncated to 1000000 bytes, and CLOB, LONG, NCLOB, and XML data is truncated to 500000 bytes. For more information, see the "Include LOBs" description in Configure an Oracle source.
Unsupported source data types
Database Ingestion and Replication does not support the following Oracle source data types with any load type:
Source columns that have unsupported data types are excluded from the target definition.
If necessary, you can create custom data-type mappings when you define an application ingestion and replication task. For more information, see Configure a Microsoft Azure Synapse Analytics target.

Oracle Source and Microsoft SQL Server Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an Oracle source and a SQL Server target:
Oracle Source Data Type
SQL Server Target Data Type
binary_double
float
binary_float
real
blob
varbinary
char
varchar
clob
varchar
date
datetime2
float
varchar
long raw
varbinary
long
varchar
nchar
nvarchar
nclob
nvarchar
number
One of the following types:
  • - decimal, 1 <= p <= 38 and s >= 0 and s <= p
  • - money, s > p or s < 0, number of digits and scale can be accommodated
  • - bigint, s <= 0, storage size can be accommodated
  • - char
nvarchar2
nvarchar
raw
varbinary
rowid
varchar
timestamp
One of the following types:
  • - datetime2, fraction seconds <=7
  • - char
timestamp with time zone
One of the following types:
  • - datetimeoffset , fractional seconds <=7
  • - char
varchar2
varchar
xml
varchar
LOB limitations
Database ingestion and replication initial load, incremental load, and combined load jobs can replicate data from Oracle BLOB, CLOB, NCLOB, LONG, LONG RAW, and XML columns to SQL Server targets. LOB column data might be truncated on the target. The truncation point depends on the data type and target type. For all of the Oracle LOB data types and this target, the truncation point is 1677721 bytes. For more information, see the "Include LOBs" description in Configure an Oracle source.
Unsupported source data types
Database Ingestion and Replication does not support the following Oracle source data types with any load type:
Source columns that have unsupported data types are excluded from the target definition.
If necessary, you can create custom data-type mappings when you define a database ingestion and replication task. For more information, see "Data Type Rules" in Configure a Microsoft SQL Server target.

Oracle Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an Oracle source and an Oracle target:
Oracle Source Data Type
Oracle Target Data Type
binary_double
binary_double
binary_float
binary_float
blob
blob
char(s byte), 1 <= size <= 2000
char(s byte), 1 <= size <= 2000
char(s char), 1 <= size <= 2000
char(s char), 1 <= size <= 2000
clob
clob
date
date
float(precision), 1 <= p <= 126
float(precision), 1 <= p <= 126
integer
integer
long raw
long raw
long(2147483648 byte)
long(2147483648 byte)
nchar(s char), 1 <= size <= 2000
nchar(s char), 1 <= size <= 2000
nclob
nclob
number
number
number(*,s), -84 <= s <= 127
number(*,s), -84 <= s <= 127
number(p,s), 1 <= p <= 38, -84 <= s <= 127
number(p,s), 1 <= p <= 38, -84 <= s <= 127
nvarchar2(s char), 1 <= size <= 4000
nvarchar2(s char), 1 <= size <= 4000
raw(size), 1 <= size <= 2000
raw(size), 1 <= size <= 2000
rowid
rowid
timestamp(precision) with time zone, 0 <= p <= 9
timestamp(precision) with time zone, 0 <= p <= 9
timestamp(precision), 1 <= p <= 9
timestamp(precision), 1 <= p <= 9
varchar2(s byte), 1 <= size <= 4000
varchar2(s byte), 1 <= size <= 4000
varchar2(s char), 1 <= size <= 4000
varchar2(s char), 1 <= size <= 4000
xml
clob
LOB limitations
Database ingestion and replication initial load, incremental load, and combined load jobs can replicate data from Oracle BLOB, CLOB, NCLOB, LONG, LONG RAW, and XML columns to Oracle targets. LOB column data might be truncated on the target. For all of the Oracle LOB data types and this target, the truncation point is 16777216 bytes. For more information, see the "Include LOBs" description in Configure an Oracle source.
Unsupported source data types
Database Ingestion and Replication does not support the following Oracle source data types with any load type:
Source columns that have unsupported data types are excluded from the target definition.
If necessary, you can create custom data-type mappings when you define a database ingestion and replication task. For more information, see "Data Type Rules" in Configure an Oracle target.

Oracle Source and PostgreSQL Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an Oracle source and a PostgreSQL target:
Oracle Source Data Type
PostgreSQL Target Data Type
binary_double
double precision
binary_float
real
blob
bytea
char(s byte), 1 <= s <= 2000
character varying(size), 1 <= size <= 500
char(s char), 1 <= s <= 2000
character varying(size), 1 <= size <= 2000
clob
text
date
timestamp(precision) without time zone, 0 <= p <= null
float(precision), 1 <= p <= 126
character varying(255)
integer
character varying(255)
long raw
bytea
long(2147483648 byte)
text
nchar(s char), 1 <= s <= 2000
character varying(size), 1 <= s <= 2000
nclob
text
number
character varying(255)
number(*,s), -84 <= s <= 127
character varying(255)
number(p,s), 1 <= p <= 38, -84 <= s <= 127
numeric(p,s), 1 <= p <= 127, 0 <= s <= 127
nvarchar2(s char), 1 <= s <= 4000
character varying(size), 1 <= s <= 4000
raw(size), 1 <= s <= 2000
bytea
rowid
character(18)
timestamp(precision) with time zone, 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
timestamp(precision) with time zone, 7 <= p <= 9
character varying(size), 67 <= size <= 69
timestamp(precision), 1 <= p <= 6
timestamp(precision) without time zone, 1 <= p <= 6
timestamp(precision), 7 <= p <= 9
character varying(size), 27 <= size <= 29
varchar2(s byte), 1 <= s <= 4000
character varying(size), 1 <= size <= 1000
varchar2(s char), 1 <= s <= 4000
character varying(size), 1 <= size <= 4000
xml
character varying
LOB limitations
Database ingestion and replication initial load, incremental load, and combined load jobs can replicate data from Oracle BLOB, CLOB, NCLOB, LONG, LONG RAW, and XML columns to PostgreSQL targets. LOB column data might be truncated on the target. For more information, see the "Include LOBs" description in Configure an Oracle source.
Unsupported source data types
Database Ingestion and Replication does not support the following Oracle source data types with any load type:
Source columns that have unsupported data types are excluded from the target definition.

Oracle Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an Oracle source and a Snowflake target:
Oracle Source Data Type
Snowflake Target Data Type
binary_double
double
binary_float
double
blob
binary
char(s byte), 1 <= size <= 2000
varchar(4)
char(s char), 1 <= size <= 2000
varchar(4)
clob
varchar
date
timestamp_ntz(0)
float(precision), 1 <= p <= 126
varchar(255)
integer
varchar(255)
long raw
binary
long(2147483648 bytes)
varchar(65535)
nchar(s char), 1 <= size <= 2000
varchar(4)
nclob
varchar
number
char(255)
number(p,s), 1<=p<=38, 0<=s<=37
number
number(p,s), 1<=p<=38, -37<=s<=-1
number, when total length is less than or equal to 38
varchar, when total length is greater than 38
nvarchar2(s char), 1 <= size <= 4000
varchar(4)
raw(size), 1 <= size <= 2000
binary(size), 1 <= size <= 2000
rowid
varchar(18)
timestamp(precision) with local time zone, 0 <= p <= 9
timestampltz (precision), 0 <= p <= 9
timestamp(precision) with time zone, 0 <= p <= 9
timestamp_tz(precision), 0 <= p <= 9
timestamp(precision), 1 <= p <= 9
timestamp_ntz(precision), 1 <= p <= 9
varchar2(s byte), 1 <= size <= 4000
varchar(size), 4 <= size <= 4000
varchar2(s char), 1 <= size <= 4000
varchar(size), 4 <= size <= 16000
xml
varchar
LOB limitations
Database ingestion and replication initial load, incremental load, and combined load jobs can replicate data from Oracle BLOB, CLOB, NCLOB, LONG, LONG RAW, and XML columns to Snowflake targets. LOB column data might be truncated on the target. For initial load jobs with a Snowflake target, BLOB and LONG RAW data is truncated to 8388608 bytes, and CLOB, LONG, NCLOB, and XML data is truncated to 16777216 bytes. For more information, see the "Include LOBs" description in Configure an Oracle source.
Unsupported source data types
Database Ingestion and Replication does not support the following Oracle source data types with any load type:
Source columns that have unsupported data types are excluded from the target definition.
If necessary, you can create custom data-type mappings when you define a database ingestion and replication task. For more information, see "Data Type Rules" in Configure a Snowflake Data Cloud target.

PostgreSQL Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a PostgreSQL source and an Amazon Redshift target:
PostgreSQL Source Data Type
Amazon Redshift Target Data Type
bigint
int8
bit varying(1)
boolean
bit varying(precision), 2 <= p <= 83886080
binary varying(size), 1 <= size <= 1024000
bit(1)
boolean
bit(precision), 2 <= p <= 83886080
binary varying(size), 1 <= size <= 1024000
boolean
boolean
box
binary varying(115)
character varying(size), 1 <= size <= 10485760
character varying(size), 4 <= size <= 65535
character(size), 1 <= size <= 10485760
character varying(size), 4 <= size <= 65535
cidr
character varying(45)
circle
binary varying(87)
date
date
daterange
character varying(29)
double precision
double precision
inet
character varying(45)
int4range
character varying(25)
int8range
character varying(43)
integer
integer
json
super
jsonb
super
line
binary varying(85)
lseg
binary varying(117)
macaddr
character varying(17)
macaddr8
character varying(23)
money
numeric(20,2)
numeric
character varying(65535)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 38 <= p <= 1000, 38 <= s <= 1000
character varying(size), 41 <= size <= 1003
numrange
character varying(65535)
path
binary varying(1024000)
point
binary varying(57)
polygon
binary varying(1024000)
real
real
smallint
smallint
time(precision) with time zone, 0 <= p <= 6
timetz
time(precision) without time zone, 0 <= p <= 6
time
timestamp(precision) with time zone, 0 <= p <= 6
timestamp with time zone
timestamp(precision) without time zone, 0 <= p <= 6
timestamp
tsrange
character varying(63)
tstzrange
character varying(75)
uuid
character(36)
xml
character varying(65535)
Limitations
Unsupported source data types
For initial load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types:
For incremental load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types, in addition to those not supported for initial load jobs:
Database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have these data types.

PostgreSQL Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a PostgreSQL source and a Databricks target:
PostgreSQL Source Data Type
Databricks Target Data Type
bigint
bigint
bit varying(precision), 1 <= p <= 83886080
binary
bit(precision), 1 <= p <= 83886080
binary
boolean
boolean
box
binary
character varying(size), 1 <= size <= 10485760
string
character(size), 1 <= size <= 10485760
string
cidr
string
circle
binary
date
string
daterange
string
double precision
double
inet
string
int4range
string
int8range
string
integer
int
json
string
jsonb
string
line
binary
lseg
binary
macaddr
string
macaddr8
string
money
decimal(19,2)
numeric
string
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 39 <= p <= 1000, 39 <= s <= 1000
string
numrange
string
path
binary
point
binary
polygon
binary
real
float
smallint
int
time(precision) with time zone, 0 <= p <= 6
string
time(precision) without time zone, 0 <= p <= 6
string
timestamp(precision) with time zone, 0 <= p <= 6
timestamp
timestamp(precision) without time zone, 0 <= p <= 6
timestamp
tsrange
string
tstzrange
string
uuid
string
xml
string
Limitations
Unsupported source data types
For initial load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types:
For incremental load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types, in addition to those not supported for initial load jobs:
Database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have these data types.

PostgreSQL Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a PostgreSQL source and a Google BigQuery target:
PostgreSQL Source Data Type
Google BigQuery Target Data Type
bigint
int64
bit varying(precision), 1 <= p <= 83886080
bytes
bit(precision), 1 <= p <= 83886080
bytes
boolean
bool
box
bytes
character varying(size), 1 <= size <= 10485760
string
character(size), 1 <= size <= 10485760
string
cidr
string
circle
bytes
date
date
daterange
string
double precision
float64
inet
string
int4range
string
int8range
string
integer
int64
json
string
jsonb
string
line
bytes
lseg
bytes
macaddr
string
macaddr8
string
money
numeric
numeric
string
numeric(1,1)
numeric
numeric(10,10)
bignumeric
numeric(11,s), 10 <= s <= 11
bignumeric
numeric(12,s), 10 <= s <= 12
bignumeric
numeric(13,s), 10 <= s <= 13
bignumeric
numeric(14,s), 10 <= s <= 14
bignumeric
numeric(15,s), 10 <= s <= 15
bignumeric
numeric(16,s), 10 <= s <= 16
bignumeric
numeric(17,s), 10 <= s <= 17
bignumeric
numeric(18,s), 10 <= s <= 18
bignumeric
numeric(19,s), 10 <= s <= 19
bignumeric
numeric(2,s), 1 <= s <= 2
numeric
numeric(20,s), 10 <= s <= 20
bignumeric
numeric(21,s), 10 <= s <= 21
bignumeric
numeric(22,s), 10 <= s <= 22
bignumeric
numeric(23,s), 10 <= s <= 23
bignumeric
numeric(24,s), 10 <= s <= 24
bignumeric
numeric(25,s), 10 <= s <= 25
bignumeric
numeric(26,s), 10 <= s <= 26
bignumeric
numeric(27,s), 10 <= s <= 27
bignumeric
numeric(28,s), 10 <= s <= 28
bignumeric
numeric(3,s), 1 <= s <= 3
numeric
numeric(38,s), 10 <= s <= 38
bignumeric
numeric(4,s), 1 <= s <= 4
numeric
numeric(5,s), 1 <= s <= 5
numeric
numeric(6,s), 1 <= s <= 6
numeric
numeric(7,s), 1 <= s <= 7
numeric
numeric(8,s), 1 <= s <= 8
numeric
numeric(precision), 1 <= p <= 18
int64
numeric(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
numeric(p,s), 29 <= p <= 30, 10 <= s <= 29
bignumeric
numeric(p,s), 30 <= p <= 31, 1 <= s <= 30
bignumeric
numeric(p,s), 31 <= p <= 32, 1 <= s <= 31
bignumeric
numeric(p,s), 32 <= p <= 33, 1 <= s <= 32
bignumeric
numeric(p,s), 33 <= p <= 34, 1 <= s <= 33
bignumeric
numeric(p,s), 34 <= p <= 35, 1 <= s <= 34
bignumeric
numeric(p,s), 35 <= p <= 36, 1 <= s <= 35
bignumeric
numeric(p,s), 36 <= p <= 37, 1 <= s <= 36
bignumeric
numeric(p,s), 37 <= p <= 38, 1 <= s <= 37
bignumeric
numeric(p,s), 39 <= p <= 1000, 39 <= s <= 1000
string
numeric(p,s), 9 <= p <= 38, 1 <= s <= 9
numeric
numrange
string
path
bytes
point
bytes
polygon
bytes
real
float64
smallint
int64
time(precision) with time zone, 0 <= p <= 6
string
time(precision) without time zone, 0 <= p <= 6
time
timestamp(precision) with time zone, 0 <= p <= 6
timestamp
timestamp(precision) without time zone, 0 <= p <= 6
datetime
tsrange
string
tstzrange
string
uuid
string
xml
string
Limitations
Unsupported source data types
For initial load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types:
For incremental load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types, in addition to those not supported for initial load jobs:
Database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have these data types.

PostgreSQL Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a PostgreSQL source and a Microsoft Azure Synapse Analytics target:
PostgreSQL Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
bigint
bigint
bit varying(1)
varbinary(size), 1 <= size <= max
bit varying(precision), 2 <= p <= 83886080
varbinary(size), 1 <= size <= max
bit(1)
bit
bit(precision), 2 <= p <= 64000
binary(size), 1 <= size <= 8000
bit(precision), 64001 <= p <= 83886080
varbinary(max)
boolean
bit
box
varbinary(115)
character varying(size), 1 <= size <= 10485760
varchar(size), 4 <= size <= max
character(size), 1 <= size <= 10485760
varchar(size), 4 <= size <= max
cidr
varchar(45)
circle
varbinary(87)
date
date
daterange
varchar(29)
double precision
float
inet
varchar(45)
int4range
varchar(25)
int8range
varchar(43)
integer
int
json
varchar(max)
jsonb
varchar(max)
line
varbinary(85)
lseg
varbinary(117)
macaddr
varchar(17)
macaddr8
varchar(23)
money
decimal(19,2)
numeric
number
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 39 <= p <= 1000, 39 <= s <= 1000
varchar(size), 42 <= s <= 1003
numrange
varchar(max)
path
varbinary(max)
point
varbinary(57)
polygon
varbinary(max)
real
real
smallint
smallint
time(precision) with time zone, 0 <= p <= 6
datetimeoffset(precision), 0 <= p <= 6
time(precision) without time zone, 0 <= p <= 6
time(precision), 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
datetimeoffset(precision), 0 <= p <= 6
timestamp(precision) without time zone, 0 <= p <= 6
datetime2(precision), 0 <= p <= 6
tsrange
varchar(63)
tstzrange
varchar(75)
uuid
uniqueidentifier
xml
varchar(max)
Limitations
Unsupported source data types
For initial load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types:
For incremental load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types, in addition to those not supported for initial load jobs:
Database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have these data types.

PostgreSQL Source and Microsoft SQL Server Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a PostgreSQL source and a Microsoft SQL Server target:
PostgreSQL Source Data Type
Microsoft SQL Server Target Data Type
bigint
bigint
bit varying(1)
bit
bit varying(p), 2 <= p <= 83886080
varbinary(p), 1 <= p <= max
bit(1)
bit
bit(p), 2 <= p <= 83886080
varbinary(p), 1 <= p <= max
boolean
bit
box
varbinary(115)
character varying(p), 1 <= p <= 10485760
varchar(p), 4 <= p <= max
character(p), 1 <= p <= 10485760
varchar(p), 4 <= p <= max
cidr
varchar(45)
circle
varbinary(87)
date
date
daterange
varchar(29)
double precision
float
inet
varchar(45)
int4range
varchar(25)
int8range
varchar(43)
integer
int
json
varchar(max)
jsonb
varchar(max)
line
varbinary(85)
lseg
varbinary(117)
macaddr
varchar(17)
macaddr8
varchar(23)
money
decimal(19,2)
numeric
varchar(max)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 39 <= p <= 1000, 39 <= s <= 1000
char(p), 42 <= p <= 1003
numrange
varchar(max)
path
varbinary(max)
point
varbinary(57)
polygon
varbinary(max)
real
real
smallint
smallint
time(p) with time zone, 0 <= p <= 6
datetimeoffset(p), 0 <= p <= 6
time(p) without time zone, 0 <= p <= 6
time(p), 0 <= p <= 6
timestamp(p) with time zone, 0 <= p <= 6
datetimeoffset(p), 0 <= p <= 6
timestamp(p) without time zone, 0 <= p <= 0
datetime2(p), 0 <= p <= 6
tsrange
varchar(63)
tstzrange
varchar(75)
uuid
uniqueidentifier
xml
xml
Note: In this table, p is precision and s is size.
Limitations
Unsupported source data types
For initial load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types:
For incremental load and initial and incremental load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types, in addition to those not supported for initial load jobs:
Database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have these data types.

PostgreSQL Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a PostgreSQL source and an Oracle target:
PostgreSQL Source Data Type
Oracle Target Data Type
bigint
number(19)
bit varying(precision), 1 <= p <= 83886080
blob
bit(precision), 1 <= p <= 83886080
blob
boolean
char(1 char)
box
blob
character varying(size), 1 <= s <= 1501
char(s char), 4 <= s <= 2000
character varying(size), 2001 <= s <= 10485760
clob
character(size), 1 <= s <= 2000
char(s char), 4 <= s <= 2000
character(size), 2100 <= s <= 10485760
clob
cidr
char(45 char)
circle
blob
date
date
daterange
char(29 char)
double precision
binary_double
inet
char(45 char)
int4range
char(25 char)
int8range
char(43 char)
integer
number(10)
json
clob
jsonb
clob
line
blob
lseg
blob
macaddr
char(17 char)
macaddr8
char(23 char)
money
number(19,2)
numeric
clob
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
number(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 39 <= p <= 1000, 39 <= s <= 1000
char(s char), 42 <= s <= 1003
numrange
clob
path
blob
point
blob
polygon
blob
real
binary_double
smallint
number(5)
time(precision) with time zone, 0 <= p <= 6
char(s char), 48 <= s <= 55
time(precision) without time zone, 0 <= p <= 6
timestamp(precision), 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
timestamp(precision) without time zone, 0 <= p <= 0
date
timestamp(precision) without time zone, 1 <= p <= 6
timestamp(precision), 1 <= p <= 6
tsrange
char(63 char)
tstzrange
char(75 char)
uuid
char(36 char)
xml
clob
Limitations
Unsupported source data types
For initial load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types:
For incremental load and initial and incremental load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types, in addition to those not supported for initial load jobs:
Database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have these data types.

PostgreSQL Source and PostgreSQL Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a PostgreSQL source and a PostgreSQL target:
PostgreSQL Source Data Type
PostgreSQL Target Data Type
bigint
bigint
bit varying(precision), 1 <= p <= 83886080
bytea
bit(precision), 1 <= p <= 83886080
bytea
boolean
boolean
box
bytea
character varying(size), 1 <= s <= 10485760
character varying(size), 1 <= s <= 10485760
character(size), 1 <= s <= 10485760
character varying(size), 1 <= s <= 10485760
cidr
cidr
circle
bytea
date
date
daterange
daterange
double precision
double precision
inet
inet
int4range
int4range
int8range
int8range
integer
integer
json
json
jsonb
jsonb
line
bytea
lseg
bytea
macaddr
macaddr
macaddr8
macaddr8
money
money
numeric
numeric
numeric(p,s), 1 <= p <= 1000, 0 <= s <= 1000
numeric(p,s), 1 <= p <= 1000, 0 <= s <= 1000
numrange
numrange
path
bytea
point
bytea
polygon
bytea
real
real
smallint
smallint
time(precision) with time zone, 0 <= p <= 6
time(precision) with time zone, 0 <= p <= 6
time(precision) without time zone, 0 <= p <= 6
time(precision) without time zone, 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
timestamp(precision) without time zone, 0 <= p <= 6
timestamp(precision) without time zone, 0 <= p <= 6
tsrange
tsrange
tstzrange
tstzrange
uuid
uuid
xml
xml
Limitations
Unsupported source data types
For initial load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types:
For incremental load and initial and incremental load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types, in addition to those not supported for initial load jobs:
Database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have these data types.

PostgreSQL Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a PostgreSQL source and a Snowflake target:
PostgreSQL Source Data Type
Snowflake Target Data Type
bigint
number
bit varying(precision), 1 <= p <= 83886080
binary(size), 1 <= size <= 6291457
bit(precision), 1 <= p <= 83886080
binary(size), 1 <= size <= 6291457
boolean
boolean
box
binary(115)
character varying(size), 1 <= size <= 10485760
varchar(size), 4 <= size <= 16776004
character(size), 1 <= size <= 10485760
varchar(size), 4 <= size <= 16776004
cidr
varchar(45)
circle
binary(87)
date
date
daterange
varchar(29)
double precision
float
inet
varchar(45)
int4range
varchar(25)
int8range
varchar(43)
integer
integer
json
variant
jsonb
variant
line
binary(85)
lseg
binary(117)
macaddr
varchar(17)
macaddr8
varchar(23)
money
number(19,2)
numeric
varchar(131074)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
number(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 38 <= p <= 1000, 38 <= s <= 1000
varchar(size), 41 <= size <= 1003
numrange
varchar(294917)
path
binary
point
binary(57)
polygon
binary
real
float
smallint
number
time(precision) with time zone, 0 <= p <= 6
timestamp_tz(precision), 0 <= p <= 6
time(precision) without time zone, 0 <= p <= 6
time(precision), 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
timestamp_tz(precision), 0 <= p <= 6
timestamp(precision) without time zone, 0 <= p <= 6
timestamp_ntz(precision), 0 <= p <= 6
tsrange
varchar(63)
tstzrange
varchar(75)
uuid
varchar
xml
variant
Limitations
Unsupported source data types
For initial load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types:
For incremental load and initial and incremental load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types, in addition to those not supported for initial load jobs:
Database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have these data types.

SAP HANA Source and Amazon Redshift Target

The following table identifies the default data-type mappings for Database Ingestion and Replication configurations with an SAP HANA or SAP HANA Cloud source and an Amazon Redshift target:
SAP HANA Source Data Type
Amazon Redshift Target Data Type
alphanum(precision), 1 <= p <= 127
character(size), 1 <= size <= 127
array
binary varying(1024000)
bigint
bigint
binary(size), 1 <= size <= 2000
binary varying(size), 1 <= size <= 2000
boolean
boolean
char(size), 1 <= size <= 2000
character(size), 1 <= size <= 2000
date
date
decimal
character varying(255)
decimal(38,38)
character varying(41)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
double
double precision
float
double precision
integer
integer
nchar(size), 1 <= size <= 2000
character varying(size), 4 <= size <= 8000
nvarchar(size), 1 <= size <= 5000
character varying(size), 4 <= size <= 20000
real
real
seconddate
timestamp without time zone
shorttext(precision), 1 <= p <= 5000
character varying(size), 1 <= size <= 5000
smalldecimal
character varying(255)
smallint
smallint
st_geometry
binary varying(1024000)
st_point
binary varying(1024000)
time
time without time zone
timestamp
character varying(27)
timestamp
timestamp without time zone
tinyint
smallint
varbinary(size), 1 <= size <= 5000
binary varying(size), 1 <= size <= 5000
varchar(size), 1 <= size <= 5000
character varying(size), 1 <= size <= 5000
Unsupported source data types:
Database Ingestion and Replication replicates only nulls for columns that have these unsupported data types.
Note: Some unsupported data types might appear in the default mappings. However, nulls are replicated for these mappings.

SAP HANA Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an SAP HANA or SAP HANA Cloud source and a Databricks target:
SAP HANA Source Data Type
Databricks Target Data Type
alphanum(precision), 1 <= p <= 127
string
array
binary
bigint
long
binary(size), 1 <= size <= 2000
binary
boolean
boolean
char(size), 1 <= s <= 2000
string
date
string
decimal
string
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
double
double
float
double
integer
integer
nchar(size), 1 <= size <= 2000
string
nvarchar(size), 1 <= size <= 5000
string
real
float
seconddate
timestamp
shorttext(precision), 1 <= p <= 5000
string
smalldecimal
string
smallint
integer
st_geometry
binary
st_point
binary
time
string
timestamp
string
timestamp
timestamp
tinyint
integer
varbinary(size), 1 <= size <= 5000
binary
varchar(size), 1 <= size <= 5000
string
Unsupported source data types:
Database Ingestion and Replication replicates only nulls for columns that have these unsupported data types.
Note: Some unsupported data types might appear in the default mappings. However, nulls are replicated for these mappings.

SAP HANA Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an SAP HANA or SAP HANA Cloud source and a Google BigQuery target:
SAP HANA Source Data Type
Google BigQuery Target Data Type
alphanum(precision), 1 <= p <= 127
string
array
bytes
bigint
int64
binary(size), 1 <= size <= 2000
bytes
boolean
bool
char(size), 1 <= size <= 2000
string
date
date
decimal
string
decimal(1,1)
numeric
decimal(10,10)
bignumeric
decimal(11,s), 10 <= s <= 11
bignumeric
decimal(12,s), 10 <= s <= 12
bignumeric
decimal(13,s), 10 <= s <= 13
bignumeric
decimal(14,s), 10 <= s <= 14
bignumeric
decimal(15,s), 10 <= s <= 15
bignumeric
decimal(16,s), 10 <= s <= 16
bignumeric
decimal(17,s), 10 <= s <= 17
bignumeric
decimal(18,s), 10 <= s <= 18
bignumeric
decimal(19,s), 10 <= s <= 19
bignumeric
decimal(2,s), 1 <= s <= 2
numeric
decimal(20,s), 10 <= s <= 20
bignumeric
decimal(21,s), 10 <= s <= 21
bignumeric
decimal(22,s), 10 <= s <= 22
bignumeric
decimal(23,s), 10 <= s <= 23
bignumeric
decimal(24,s), 10 <= s <= 24
bignumeric
decimal(25,s), 10 <= s <= 25
bignumeric
decimal(26,s), 10 <= s <= 26
bignumeric
decimal(27,s), 10 <= s <= 27
bignumeric
decimal(28,s), 10 <= s <= 28
bignumeric
decimal(3,s), 1 <= s <= 3
numeric
decimal(38,s), 10 <= s <= 38
bignumeric
decimal(4,s), 1 <= s <= 4
numeric
decimal(5,s), 1 <= s <= 5
numeric
decimal(6,s), 1 <= s <= 6
numeric
decimal(7,s), 1 <= s <= 7
numeric
decimal(8,s), 1 <= s <= 8
numeric
decimal(p,0), 1 <= p <= 18
int64
decimal(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
decimal(p,s), 29 <= p <= 30, 0 <= s <= 29
bignumeric
decimal(p,s), 30 <= p <= 31, 0 <= s <= 30
bignumeric
decimal(p,s), 31 <= p <= 32, 0 <= s <= 31
bignumeric
decimal(p,s), 32 <= p <= 33, 0 <= s <= 32
bignumeric
decimal(p,s), 33 <= p <= 34, 0 <= s <= 33
bignumeric
decimal(p,s), 34 <= p <= 35, 0 <= s <= 34
bignumeric
decimal(p,s), 35 <= p <= 36, 0 <= s <= 35
bignumeric
decimal(p,s), 36 <= p <= 37, 0 <= s <= 36
bignumeric
decimal(p,s), 37 <= p <= 38, 0 <= s <= 37
bignumeric
decimal(p,s), 9 <= p <= 38, 1 <= s <= 9
numeric
double
float64
float
float64
integer
int64
nchar(size), 1 <= size <= 2000
string
nvarchar(size), 1 <= size <= 5000
string
real
float64
seconddate
datetime
shorttext(precision), 1 <= p <= 5000
string
smalldecimal
string
smallint
int64
st_geometry
bytes
st_point
bytes
time
time
timestamp
datetime
timestamp
string
tinyint
int64
varbinary(size), 1 <= size <= 5000
bytes
varchar(size), 1 <= size <= 5000
string
Unsupported source data types:
Database Ingestion and Replication replicates only nulls for columns that have these unsupported data types.
Note: Some unsupported data types might appear in the default mappings. However, nulls are replicated for these mappings.

SAP HANA Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an SAP HANA or SAP HANA Cloud source and a Microsoft Azure Synapse Analytics target:
SAP HANA Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
alphanum(precision), 1 <= p <= 127
char(size), 1 <= size <= 127
array
varbinary(max)
bigint
bigint
binary(size), 1 <= size <= 2000
binary(size), 1 <= size <= 2000
boolean
bit
char(size), 1 <= size <= 2000
char(size), 1 <= size <= 2000
date
date
decimal
varchar(255)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
double
float
float
float
integer
int
nchar(size), 1 <= size <= 2000
char(size), 4 <= size <= 8000
nvarchar(size), 1 <= size <= 5000
varchar(size), 4 <= size <= max
real
real
seconddate
datetime2(0)
shorttext(precision), 1 <= p <= 5000
varchar(size), 1 <= s <= 5000
smalldecimal
varchar(255)
smallint
smallint
st_geometry
varbinary(max)
st_point
varbinary(max)
time
time(0)
timestamp
datetime2(precision), 0 <= p <= 7
tinyint
tinyint
varbinary(size), 1 <= size <= 5000
varbinary(size), 1 <= size <= 5000
varchar(size), 1 <= size <= 5000
varchar(size), 1 <= size <= 5000
Unsupported source data types:
Database Ingestion and Replication replicates only nulls for columns that have these unsupported data types.
Note: Some unsupported data types might appear in the default mappings. However, nulls are replicated for these mappings.

SAP HANA Source and Microsoft SQL Server Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an SAP HANA or SAP HANA Cloud source and a Microsoft SQL Server target:
SAP HANA Source Data Type
Microsoft SQL Server Target Data Type
alphanum(precision), 1 <= p <= 127
varchar(size), 1 <= size <= 127
array
varbinary(max)
bigint
bigint
binary(size), 1 <= size <= 2000
varbinary(size), 1 <= size <= 2000
boolean
bit
char(size), 1 <= size <= 2000
varchar(size), 1 <= size <= 2000
date
date
decimal
char(255)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
double
float
float
float
integer
int
nchar(size), 1 <= size <= 2000
nvarchar(size), 4 <= size <= 8000
nvarchar(size), 1 <= size <= 5000
nvarchar(size), 4 <= size <= max
real
real
real
real
seconddate
datetime2(0)
shorttext(precision), 1 <= p <= 5000
varchar(size), 1 <= size <= 5000
smalldecimal
char(255)
smallint
smallint
st_geometry
varbinary(max)
st_point
varbinary(max)
time
time(0)
timestamp
datetime2(precision), 0 <= p <= 7
tinyint
tinyint
varbinary(size), 1 <= size <= 5000
varbinary(size), 1 <= size <= 5000
varchar(size), 1 <= size <= 5000
varchar(size), 1 <= size <= 5000
Unsupported source data types:
Database Ingestion and Replication replicates only nulls for columns that have these unsupported data types.
Note: Some unsupported data types might appear in the default mappings. However, nulls are replicated for these mappings.

SAP HANA Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an SAP HANA or SAP HANA Cloud source and an Oracle target:
SAP HANA Source Data Type
Oracle Target Data Type
alphanum(precision), 1 <= p <= 127
varchar2(s char), 1 <= s <= 127
array
blob
bigint
number(19)
binary(size), 1 <= size <= 2000
raw(size), 1 <= size <= 2000
boolean
char(1 char)
char(size), 1 <= size <= 2000
varchar2(s byte), 1 <= s <= 2000
date
date
decimal
char(255 char)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
number(p,s), 1 <= p <= 38, 0 <= s <= 38
double
binary_double
float
binary_double
integer
number(10)
nchar(size), 1 <= size <= 1000
nvarchar2(s char), 1 <= s <= 1000
nchar(size), 1001 <= size <= 2000
char(2000 char)
nvarchar(size), 1 <= size <= 901
nvarchar2(s char), 1 <= s <= 901
nvarchar(size), 1001 <= size <= 1901
char(2000 char)
nvarchar(size), 2001 <= size <= 5000
clob
real
binary_float
real
binary_float
seconddate
date
shorttext(precision), 1 <= p <= 3901
varchar2(s char), 1 <= s <= 3901
shorttext(precision), 4001 <= p <= 5000
clob
smalldecimal
char(255 char)
smallint
number(5)
st_geometry
blob
st_point
blob
time
timestamp(0)
timestamp
date
timestamp
timestamp(precision), 1 <= p <= 7
tinyint
number(3)
varbinary(size), 1 <= size <= 1501
raw(size), 1 <= size <= 1501
varchar(size), 1 <= size <= 3901
varchar2(s byte), 1 <= s <= 3901
varchar(size), 4001 <= size <= 5000
clob
Unsupported source data types:
Database Ingestion and Replication replicates only nulls for columns that have these unsupported data types.
Note: Some unsupported data types might appear in the default mappings. However, nulls are replicated for these mappings.

SAP HANA Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an SAP HANA or SAP HANA Cloud source and a Snowflake target:
SAP HANA Source Data Type
Snowflake Target Data Type
alphanum(precision), 1 <= p <= 127
char(size), 1 <= size <= 127
array
binary
bigint
integer
binary(size), 1 <= size <= 2000
binary(size), 1 <= size <= 2000
boolean
boolean
char(size), 1 <= size <= 2000
char(size), 1 <= size <= 2000
date
date
decimal
char(255)
decimal(38,38)
char(41)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37
number(p,s), 1 <= p <= 38, 0 <= s <= 37
double
float
float
float
integer
integer
nchar(size), 1 <= size <= 2000
char(size), 4 <= size <= 8000
nvarchar(size), 1 <= size <= 5000
varchar(size), 4 <= size <= 20000
real
float
seconddate
timestamp_ntz(0)
shorttext(precision), 1 <= p <= 5000
varchar(size), 1 <= size <= 5000
smalldecimal
char(255)
smallint
integer
st_geometry
binary
st_point
binary
time
time(0)
timestamp
timestamp_ntz(precision), 0 <= p <= 7
tinyint
integer
varbinary(size), 1 <= size <= 5000
binary(size), 1 <= size <= 5000
varchar(size), 1 <= size <= 5000
varchar(size), 1 <= size <= 5000
Unsupported source data types:
Database Ingestion and Replication replicates only nulls for columns that have these unsupported data types.
Note: Some unsupported data types might appear in the default mappings. However, nulls are replicated for these mappings.

Teradata Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Teradata source and an Amazon Redshift target:
Teradata Source Data Type
Amazon Redshift Target Data Type
array
binary varying(1024000)
bigint
bigint
blob
binary varying(1024000)
byte(precision), 1 <= p <= 64000
binary varying(size), 1 <= size <= 64000
byteint
smallint
char(size), 1 <= size <= 64000
character varying(size), 4 <= size <= 65535
clob
character varying(65535)
date
date
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
float
double precision
integer
integer
interval day(precision) to hour, 1 <= p <= 4
character varying(size), 5 <= size <= 8
interval day(precision) to minute, 1 <= p <= 4
character varying(size), 8 <= size <= 11
interval day(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
character varying(size), 12 <= size <= 21
interval day(precision), 1 <= p <= 4
character varying(size), 2 <= size <= 5
interval hour(precision) to minute, 1 <= p <= 4
character varying(size), 5 <= size <= 8
interval hour(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
character varying(size), 9 <= size <= 18
interval hour(precision), 1 <= p <= 4
character varying(size), 2 <= size <= 5
interval minute(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
character varying(size), 9 <= size <= 18
interval minute(precision), 1 <= p <= 4
character varying(size), 2 <= size <= 5
interval month(precision), 1 <= p <= 4
character varying(size), 2 <= size <= 5
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6
character varying(size), 3 <= size <= 12
interval year(precision) to month, 1 <= p <= 4
character varying(size), 5 <= size <= 8
interval year(precision), 1 <= p <= 4
character varying(size), 2 <= size <= 5
json
character varying(65535)
mbr
binary varying(256)
number(*,s), 0 <= s <= 37
character varying(255)
number(p,s), 1 <= p <= 38, 1 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
period(date)
character varying(28)
period(time(precision) with time zone), 0 <= p <= 6
character varying(size), 36 <= size <= 50
period(time(precision) ), 0 <= p <= 6
character varying(size), 24 <= size <= 38
period(timestamp(precision) with time zone), 0 <= p <= 6
character varying(size), 58 <= size <= 72
period(timestamp(precision) ), 0 <= p <= 6
character varying(size), 46 <= size <= 60
smallint
smallint
time(precision) with time zone, 0 <= p <= 6
timetz
time(precision), 0 <= p <= 6
time without time zone
timestamp(precision) with time zone, 0 <= p <= 6
timestamp with time zone
timestamp(precision), 0 <= p <= 6
timestamp without time zone
varbyte(precision), 1 <= p <= 64000
binary varying(size), 1 <= size <= 64000
varchar(size), 1 <= size <= 64000
character varying(size), 4 <= size <= 65535
varray
binary varying(1024000)
xml
character varying(65535)
Unsupported source data types
Database Ingestion and Replication does not support the following Teradata data types:
Note: Most of the unsupported data types appear in the default mappings. However, nulls are replicated for these mappings.

Teradata Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Teradata source and a Databricks target:
Teradata Source Data Type
Databricks Target Data Type
array
binary
bigint
long
blob
binary
byte(precision), 1 <= p <= 64000
binary
byteint
integer
char(size), 1 <= size <= 64000
string
clob
string
date
string
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
float
double
integer
integer
interval day(precision) to hour, 1 <= p <= 4
string
interval day(precision) to minute, 1 <= p <= 4
string
interval day(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
string
interval day(precision), 1 <= p <= 4
string
interval hour(precision) to minute, 1 <= p <= 4
string
interval hour(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
string
interval hour(precision), 1 <= p <= 4
string
interval minute(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
string
interval minute(precision), 1 <= p <= 4
string
interval month(precision), 1 <= p <= 4
string
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6
string
interval year(precision) to month, 1 <= p <= 4
string
interval year(precision), 1 <= p <= 4
string
json
string
mbr
binary
number(*,s), 0 <= s <= 37
string
number(p,s), 1 <= p <= 38, 1 <= s <= 37
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
period(date)
string
period(time(precision) with time zone), 0 <= p <= 6
string
period(time(precision) ), 0 <= p <= 6
string
period(timestamp(precision) with time zone), 0 <= p <= 6
string
period(timestamp(precision) ), 0 <= p <= 6
string
smallint
integer
time(precision) with time zone, 0 <= p <= 6
string
time(precision), 0 <= p <= 6
string
timestamp(precision) with time zone, 0 <= p <= 6
timestamp
timestamp(precision), 0 <= p <= 6
timestamp
varbyte(precision), 1 <= p <= 64000
binary
varchar(size), 1 <= size <= 64000
string
varray
binary
xml
string
Unsupported source data types
Database Ingestion and Replication does not support the following Teradata data types:
Note: Most of the unsupported data types appear in the default mappings. However, nulls are replicated for these mappings.

Teradata Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Teradata source and a Google BigQuery target:
Teradata Source Data Type
Google BigQuery Target Data Type
array
bytes
bigint
int64
blob
bytes
byte(precision), 1 <= p <= 64000
bytes
byteint
int64
char(size), 1 <= size <= 64000
string
clob
string
date
date
decimal(10,10)
bignumeric
decimal(11,s), 10 <= s <= 11
bignumeric
decimal(12,s), 10 <= s <= 12
bignumeric
decimal(13,s), 10 <= s <= 13
bignumeric
decimal(14,s), 10 <= s <= 14
bignumeric
decimal(15,s), 10 <= s <= 15
bignumeric
decimal(16,s), 10 <= s <= 16
bignumeric
decimal(17,s), 10 <= s <= 17
bignumeric
decimal(18,s), 10 <= s <= 18
bignumeric
decimal(19,s), 10 <= s <= 19
bignumeric
decimal(20,s), 10 <= s <= 20
bignumeric
decimal(21,s), 10 <= s <= 21
bignumeric
decimal(22,s), 10 <= s <= 22
bignumeric
decimal(23,s), 10 <= s <= 23
bignumeric
decimal(24,s), 10 <= s <= 24
bignumeric
decimal(25,s), 10 <= s <= 25
bignumeric
decimal(26,s), 10 <= s <= 26
bignumeric
decimal(27,s), 10 <= s <= 27
bignumeric
decimal(28,s), 10 <= s <= 28
bignumeric
decimal(29,s), 10 <= s <= 29
bignumeric
decimal(precision), 1 <= p <= 18
int64
decimal(precision), 19 <= p <= 29
numeric
decimal(precision), 30 <= p <= 38
bignumeric
decimal(p,s), 1 <= p <= 38, 1 <= s <= 9
numeric
decimal(p,s), 30 <= p <= 31, 1 <= s <= 30
bignumeric
decimal(p,s), 31 <= p <= 32, 1 <= s <= 31
bignumeric
decimal(p,s), 32 <= p <= 33, 1 <= s <= 32
bignumeric
decimal(p,s), 33 <= p <= 34, 1 <= s <= 33
bignumeric
decimal(p,s), 34 <= p <= 35, 1 <= s <= 34
bignumeric
decimal(p,s), 35 <= p <= 36, 1 <= s <= 35
bignumeric
decimal(p,s), 36 <= p <= 37, 1 <= s <= 36
bignumeric
decimal(p,s), 37 <= p <= 38, 1 <= s <= 37
bignumeric
float
float64
integer
int64
interval day(precision) to hour, 1 <= p <= 4
string
interval day(precision) to minute, 1 <= p <= 4
string
interval day(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
string
interval day(precision), 1 <= p <= 4
string
interval hour(precision) to minute, 1 <= p <= 4
string
interval hour(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
string
interval hour(precision), 1 <= p <= 4
string
interval minute(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
string
interval minute(precision), 1 <= p <= 4
string
interval month(precision), 1 <= p <= 4
string
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6
string
interval year(precision) to month, 1 <= p <= 4
string
interval year(precision), 1 <= p <= 4
string
json
string
mbr
bytes
number(*,s), 0 <= s <= 37
string
number(10,10)
bignumeric
number(11,s), 10 <= s <= 11
bignumeric
number(12,s), 10 <= s <= 12
bignumeric
number(13,s), 10 <= s <= 13
bignumeric
number(14,s), 10 <= s <= 14
bignumeric
number(15,s), 10 <= s <= 15
bignumeric
number(16,s), 10 <= s <= 16
bignumeric
number(17,s), 10 <= s <= 17
bignumeric
number(18,s), 10 <= s <= 18
bignumeric
number(19,s), 10 <= s <= 19
bignumeric
number(20,s), 10 <= s <= 20
bignumeric
number(21,s), 10 <= s <= 21
bignumeric
number(22,s), 10 <= s <= 22
bignumeric
number(23,s), 10 <= s <= 23
bignumeric
number(24,s), 10 <= s <= 24
bignumeric
number(25,s), 10 <= s <= 25
bignumeric
number(26,s), 10 <= s <= 26
bignumeric
number(27,s), 10 <= s <= 27
bignumeric
number(28,s), 10 <= s <= 28
bignumeric
number(29,s), 10 <= s <= 29
bignumeric
number(precision), 1 <= p <= 18
int64
number(precision), 19 <= p <= 29
numeric
number(precision), 30 <= p <= 36
bignumeric
number(p,s), 1 <= p <= 38, 1 <= s <= 9
numeric
number(p,s), 30 <= p <= 31, 1 <= s <= 30
bignumeric
number(p,s), 31 <= p <= 32, 1 <= s <= 31
bignumeric
number(p,s), 32 <= p <= 33, 1 <= s <= 32
bignumeric
number(p,s), 33 <= p <= 34, 1 <= s <= 33
bignumeric
number(p,s), 34 <= p <= 35, 1 <= s <= 34
bignumeric
number(p,s), 35 <= p <= 36, 1 <= s <= 35
bignumeric
number(p,s), 36 <= p <= 37, 1 <= s <= 36
bignumeric
number(p,s), 37 <= p <= 38, 1 <= s <= 37
bignumeric
numeric(10,10)
bignumeric
numeric(11,s), 10 <= s <= 11
bignumeric
numeric(12,s), 10 <= s <= 12
bignumeric
numeric(13,s), 10 <= s <= 13
bignumeric
numeric(14,s), 10 <= s <= 14
bignumeric
numeric(15,s), 10 <= s <= 15
bignumeric
numeric(16,s), 10 <= s <= 16
bignumeric
numeric(17,s), 10 <= s <= 17
bignumeric
numeric(18,s), 10 <= s <= 18
bignumeric
numeric(19,s), 10 <= s <= 19
bignumeric
numeric(20,s), 10 <= s <= 20
bignumeric
numeric(21,s), 10 <= s <= 21
bignumeric
numeric(22,s), 10 <= s <= 22
bignumeric
numeric(23,s), 10 <= s <= 23
bignumeric
numeric(24,s), 10 <= s <= 24
bignumeric
numeric(25,s), 10 <= s <= 25
bignumeric
numeric(26,s), 10 <= s <= 26
bignumeric
numeric(27,s), 10 <= s <= 27
bignumeric
numeric(28,s), 10 <= s <= 28
bignumeric
numeric(29,s), 10 <= s <= 29
bignumeric
numeric(precision), 1 <= p <= 18
int64
numeric(precision), 19 <= p <= 29
numeric
numeric(precision), 30 <= p <= 36
bignumeric
numeric(p,s), 1 <= p <= 38, 1 <= s <= 9
numeric
numeric(p,s), 30 <= p <= 31, 1 <= s <= 30
bignumeric
numeric(p,s), 31 <= p <= 32, 1 <= s <= 31
bignumeric
numeric(p,s), 32 <= p <= 33, 1 <= s <= 32
bignumeric
numeric(p,s), 33 <= p <= 34, 1 <= s <= 33
bignumeric
numeric(p,s), 34 <= p <= 35, 1 <= s <= 34
bignumeric
numeric(p,s), 35 <= p <= 36, 1 <= s <= 35
bignumeric
numeric(p,s), 36 <= p <= 37, 1 <= s <= 36
bignumeric
numeric(p,s), 37 <= p <= 38, 1 <= s <= 37
bignumeric
period(date)
string
period(time(precision) with time zone), 0 <= p <= 6
string
period(time(precision) ), 0 <= p <= 6
string
period(timestamp(precision) with time zone), 0 <= p <= 6
string
period(timestamp(precision) ), 0 <= p <= 6
string
smallint
int64
time(precision) with time zone, 0 <= p <= 6
timestamp
time(precision), 0 <= p <= 6
time
timestamp(precision) with time zone, 0 <= p <= 6
timestamp
timestamp(precision), 0 <= p <= 6
datetime
varbyte(precision), 1 <= p <= 64000
bytes
varchar(size), 1 <= size <= 64000
string
varray
bytes
xml
string
Unsupported source data types
Database Ingestion and Replication does not support the following Teradata data types:
Note: Most of the unsupported data types appear in the default mappings. However, nulls are replicated for these mappings.

Teradata Source and Microsoft Azure Synapse Analytics Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Teradata source and a Microsoft Azure Synapse Analytics target:
Teradata Source Data Type
Microsoft Azure Synapse Analytics Target Data Type
array
varbinary(max)
bigint
bigint
blob
varbinary(max)
byte(precision), 1 <= p <= 7501
binary(size), 1 <= size <= 7501
byte(precision), 8001 <= p <= 64000
varbinary(max)
byteint
smallint
char(size), 1 <= size <= 8000
char(size), 1 <= size <= 8000
char(size), 8001 <= size <= 64000
varchar(max)
clob
varchar(max)
date
date
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
float
float
integer
int
interval day(precision) to hour, 1 <= p <= 4
varchar(size), 5 <= size <= 8
interval day(precision) to minute, 1 <= p <= 4
varchar(size), 8 <= size <= 11
interval day(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
varchar(size), 12 <= size <= 21
interval day(precision), 1 <= p <= 4
varchar(size), 2 <= size <= 5
interval hour(precision) to minute, 1 <= p <= 4
varchar(size), 5 <= size <= 8
interval hour(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
varchar(size), 9 <= size <= 18
interval hour(precision), 1 <= p <= 4
varchar(size), 2 <= size <= 5
interval minute(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
varchar(size), 9 <= size <= 18
interval minute(precision), 1 <= p <= 4
varchar(size), 2 <= size <= 5
interval month(precision), 1 <= p <= 4
varchar(size), 2 <= size <= 5
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6
varchar(size), 3 <= size <= 12
interval year(precision) to month, 1 <= p <= 4
varchar(size), 5 <= size <= 8
interval year(precision), 1 <= p <= 4
varchar(size), 2 <=size <= 5
json
varchar(max)
mbr
varbinary(256)
number(*,s), 0 <= s <= 37
varchar(255)
number(p,s), 1 <= p <= 38, 1 <= s <= 37
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
period(date)
varchar(28)
period(time(precision) with time zone), 0 <= p <= 6
varchar(size), 36 <= size <= 50
period(time(precision) ), 0 <= p <= 6
varchar(size), 24 <= size <= 38
period(timestamp(precision) with time zone), 0 <= p <= 6
varchar(size), 58 <= size <= 72
period(timestamp(precision) ), 0 <= p <= 6
varchar(size), 46 <= size <= 60
smallint
smallint
time(precision) with time zone, 0 <= p <= 6
datetimeoffset(precision), 0 <= p <= 6
time(precision), 0 <= p <= 6
time(precision), 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
datetimeoffset(precision), 0 <= p <= 6
timestamp(precision), 0 <= p <= 6
datetime2(precision), 0 <= p <= 6
varbyte(precision), 1 <= p <= 64000
varbinary(size), 1 <= size <= max
varchar(size), 1 <= size <= 64000
varchar(size), 1 <= size <= max
varray
varbinary(max)
xml
varchar(max)
Unsupported source data types
Database Ingestion and Replication does not support the following Teradata data types:
Note: Most of the unsupported data types appear in the default mappings. However, nulls are replicated for these mappings.

Teradata Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Teradata source and an Oracle target:
Teradata Source Data Type
Oracle Target Data Type
array
blob
bigint
number(19)
blob
blob
byte(precision), 1 <= p <= 64000
blob
byteint
number(3)
char(size), 1 <= size <= 2000
char(s byte), 1 <= s <= 2000
char(size), 2001 <= size <= 64000
clob
clob
clob
date
date
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
number(p,s), 1 <= p <= 38, 1 <= s <= 37
float
binary_double
integer
number(10)
interval day(precision) to hour, 1 <= p <= 4
char(s char), 5 <= s <= 8
interval day(precision) to minute, 1 <= p <= 4
char(s char), 8 <= s <= 11
interval day(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
char(s char), 12 <= s <= 21
interval day(precision), 1 <= p <= 4
char(s char), 2 <= s <= 5
interval hour(precision) to minute, 1 <= p <= 4
char(s char), 5 <= s <= 8
interval hour(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
char(s char), 9 <= s <= 18
interval hour(precision), 1 <= p <= 4
char(s char), 2 <= s <= 5
interval minute(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
char(s char), 9 <= s <= 18
interval minute(precision), 1 <= p <= 4
char(s char), 2 <= s <= 5
interval month(precision), 1 <= p <= 4
char(s char), 2 <= s <= 5
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6
char(s char), 3 <= s <= 12
interval year(precision) to month, 1 <= p <= 4
char(s char), 5 <= s <= 8
interval year(precision), 1 <= p <= 4
char(s char), 2 <= s <= 5
json
clob
mbr
blob
number(*,s), 0 <= s <= 37
char(255 char)
number(p,s), 1 <= p <= 38, 1 <= s <= 37
number(p,s), 1 <= p <= 38, 1 <= s <= 37
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37
number(p,s), 1 <= p <= 38, 1 <= s <= 37
period(date)
char(28 char)
period(time(precision) with time zone), 0 <= p <= 6
char(s char), 36 <= s <= 50
period(time(precision) ), 0 <= p <= 6
char(s char), 24 <= s <= 38
period(timestamp(precision) with time zone), 0 <= p <= 6
char(s char), 58 <= s <= 72
period(timestamp(precision) ), 0 <= p <= 6
char(s char), 46 <= s <= 60
smallint
number(5)
time(precision) with time zone, 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
time(precision), 0 <= p <= 6
timestamp(precision), 0 <= p <= 6
timestamp(0)
date
timestamp(precision) with time zone, 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
timestamp(precision), 1 <= p <= 6
timestamp(precision), 1 <= p <= 6
varbyte(precision), 1 <= p <= 64000
blob
varchar(size), 1 <= size <= 1501
char(s byte), 1 <= s <= 1501
varchar(size), 2001 <= size <= 64000
clob
varray
blob
xml
clob
Unsupported source data types
Database Ingestion and Replication does not support the following Teradata data types:
Note: Most of the unsupported data types appear in the default mappings. However, nulls are replicated for these mappings.

Teradata Source and Snowflake Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Teradata source and a Snowflake target:
Teradata Source Data Type
Snowflake Target Data Type
array
binary
bigint
integer
blob
binary
byte(precision), 1 <= p <= 64000
binary(size), 1 <= size <= 64000
byteint
integer
char(size), 1 <= size <= 64000
varchar(size), 4 <= size <= 256000
clob
varchar
date
date
decimal(precision), 1 <= p <= 38
integer
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
number(p,s), 1 <= p <= 38, 1 <= s <= 37
float
float
integer
integer
interval day(precision) to hour, 1 <= p <= 4
varchar(size), 5 <= size <= 8
interval day(precision) to minute, 1 <= p <= 4
varchar(size), 8 <= size <= 11
interval day(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
varchar(size), 12 <= size <= 21
interval day(precision), 1 <= p <= 4
varchar(size), 2 <= size <= 5
interval hour(precision) to minute, 1 <= p <= 4
varchar(size), 5 <= size <= 8
interval hour(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
varchar(size), 9 <= size <= 18
interval hour(precision), 1 <= p <= 4
varchar(size), 2 <= size <= 5
interval minute(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6
varchar(size), 9 <= size <= 18
interval minute(precision), 1 <= p <= 4
varchar(size), 2 <= size <= 5
interval month(precision), 1 <= p <= 4
varchar(size), 2 <= size <= 5
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6
varchar(size), 3 <= size <= 12
interval year(precision) to month, 1 <= p <= 4
varchar(size), 5 <= size <= 8
interval year(precision), 1 <= p <= 4
varchar(size), 2 <= size <= 5
json
varchar
mbr
binary(256)
number(*,s), 0 <= s <= 37
char(255)
number(precision), 1 <= p <= 36
integer
number(p,s), 1 <= p <= 38, 1 <= s <= 37
number(p,s), 1 <= p <= 38, 1 <= s <= 37
numeric(precision), 1 <= p <= 36
integer
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37
number(p,s), 1 <= p <= 38, 1 <= s <= 37
period(date)
varchar(28)
period(time(precision) with time zone), 0 <= p <= 6
varchar(size), 36 <= size <= 50
period(time(precision) ), 0 <= p <= 6
varchar(size), 24 <= size <= 38
period(timestamp(precision) with time zone), 0 <= p <= 6
varchar(size), 58 <= size <= 72
period(timestamp(precision) ), 0 <= p <= 6
varchar(size), 46 <= size <= 60
smallint
integer
time(precision) with time zone, 0 <= p <= 6
timestamp_tz(precision), 0 <= p <= 6
time(precision), 0 <= p <= 6
time(precision), 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6
timestamp_tz(precision), 0 <= p <= 6
timestamp(precision), 0 <= p <= 6
timestamp_ntz(precision), 0 <= p <= 6
varbyte(precision), 1 <= p <= 64000
binary(size), 1 <= size <= 64000
varchar(size), 1 <= size <= 64000
varchar(size), 4 <= size <= 256000
varray
binary
xml
varchar
Note: The Snowflake TIMESTAMP_TZ data type includes a default date that the source Teradata TIME WITH TIME ZONE data type does not include. For example, a database ingestion job will replicate the source value "12:59:59" as "1900-01-01 12:59:59".
Unsupported source data types
Database Ingestion and Replication does not support the following Teradata data types:
Note: Most of the unsupported data types appear in the default mappings. However, nulls are replicated for these mappings.