Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Microsoft SQL Server Source Data Type
| Databricks Delta Target Data Type
|
|---|---|
bigint
| long
|
binary( size ), 1 <= s <= 8000
| binary
|
bit
| boolean
|
char( size ), 1 <= s <= 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 <= s <= 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 <= s <= 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 <= s <= 8000
| binary
|
varchar( size ), 1 <= s <= 8000
| string
|
xml
| string
|
