SQL Server datatype mapping - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

SQL Server Source Datatype

Snowflake Target Datatype

BIGINT

Number(38,0)

BINARY

Binary(1)

BINARY(p)

Binary(p)

BIT

Number(38,0)

CHAR

Varchar(1)

CHAR VARYING(p)

Varchar(p)

CHAR(p)

Varchar(p)

DATE

Date

DATETIME

TimeStamp_ntz(9)

DATETIME2

TimeStamp_ntz(9)

DATETIME2(6)

TimeStamp_ntz(9)

DATETIMEOFFSET

TimeStamp_ntz(9)

DATETIMEOFFSET(6)

TimeStamp_ntz(9)

DECIMAL

Number(18,0)

DECIMAL(p,s)

Number(p,s)

DECIMAL(p)

Number(p)

DECIMAL(p,s)

Number(p,s)

DOUBLE PRECISION

Float

FLOAT

Float

FLOAT(10)

Float

IMAGE

Binary(8388608)

INTEGER

Number(38,0)

MONEY

Number(19,4)

NCHAR

Varchar(1)

NCHAR VARYING(p)

Varchar(p)

NCHAR(p)

Varchar(p)

NTEXT

Varchar(16777216)

NUMERIC

Number(18,0)

NUMERIC(p,s)

Number(p,s)

NVARCHAR

Varchar(1)

NVARCHAR(p)

Varchar(p)

NVARCHAR(MAX)

Varchar(16777216)

REAL

Float

SMALLDATETIME

Timestamp_ntz(9)

SMALLINT

Number(38,0)

SMALLMONEY

Number(10,4)

TEXT

Varchar(16777216)

TIME

Time(9)

TIME(p)

Time(9)

TINYINT

Number(38,0)

UNIQUEIDENTIFIER

Varchar(36)

VARBINARY

Binary(8388608)

VARBINARY(p)

Binary(8388608)

VARBINARY(MAX)

Binary(8388608)

VARCHAR

Varchar(1)

VARCHAR(p)

Varchar(p)

VARCHAR(MAX)

Varchar(16777216)

XML

Varchar(16777216)

The following table shows the SQL Server source datatypes that are available to map to a varchar target column in a table you create manually on the Snowflake target. If you create the varchar with no precision, by default the size will be 16777216. If you create a fixed-length varchar datatype, ensure this target definition is large enough to accommodate the data sent from the source column.

SQL Server Source Datatype

Snowflake Target Varchar

BIG INT

Varchar

BIT

Varchar

Date

Varchar

Datetime

Varchar

Datetime2

Varchar

Datetimeoffset

Varchar

Decimal

Varchar

Double

Varchar

Float

Varchar

Integer

Varchar

Numeric

Varchar

Real

Varchar

Small Datetime

Varchar

Smallint

Varchar

Time

Varchar

Tinyint

Varchar