Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
SAP HANA Source Data Type
| Google BigQuery Target Data Type
|
---|---|
alphanum( precision ), 1 <= p <= 127
| string
|
array
| bytes
|
bigint
| int64
|
binary( size ), 1 <= s <= 2000
| bytes
|
boolean
| bool
|
char( size ), 1 <= s <= 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,1), 18 <= p <= 0
| 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 <= s <= 2000
| string
|
nvarchar( size ), 1 <= s <= 5000
| string
|
real
| float64
|
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 <= s <= 5000
| bytes
|
varchar( size ), 1 <= s <= 5000
| string
|