MSSQL到Snowflake的数据类型映射

Question

是否有人拥有从MSSQL(Azure MSSQL(到Snowflake的数据类型映射？

这是我目前拥有的映射：

# Key: MSSQL, value: Snowflake
DATA_TYPE_MAPPING = {
"BIGINT": "BIGINT",
"BINARY": "BLOB",
"BIT": "BOOLEAN",
"DATE": "DATE",
"DATETIME": "DATETIME",
"DATETIME2": "DATETIME",
"DOUBLE": "DOUBLE",
"DECIMAL": "DECIMAL",
"FLOAT": "FLOAT",
"ENUM": "STRING",
"SET": "STRING",
"IMAGE": "BINARY",
"INT": "INT",
"INTEGER": "INTEGER",
"LONGTEXT": "VARCHAR",
"MEDIUMINT": "INTEGER",
"MEDIUMTEXT": "VARCHAR",
"NUMERIC": "NUMBER",
"REAL": "FLOAT4",
"SMALLINT": "SMALLINT",
"TEXT": "VARCHAR",
"TIME": "TIME",
"TIMESTAMP": "TIMESTAMP",
"TINYTEXT": "STRING",
"TINYINT": "TINYINT",
"VARCHAR": "VARCHAR",
"VARBINARY": "VARBINARY",
}

我找不到完整的地图。如果有人知道，请告诉我们。

Answer 1

Microsoft SQL Server到Snowflake迁移参考手册中描述了数据类型映射

附录A:MICROSOFT SQL SERVER雪花特征映射

小节：数据类型

Answer 2

在阅读了本文中提到的Microsoft SQL Server到Snowflake迁移参考手册后，我将初始映射更改为：

MSSQL_SNOWFLAKE_DATA_TYPE_MAPPING = {
"BIGINT": "NUMBER",
"BINARY": "BINARY",
"BIT": "BOOLEAN",
"CHAR": "VARCHAR(1)",
"DATE": "DATE",
"DATETIME": "DATETIME",
"DATETIME2": "TIMESTAMP_NTZ",
"DATETIMEOFFSET": "TIMESTAMP_LTZ",
"DOUBLE": "DOUBLE",
"DECIMAL": "NUMBER",
"FLOAT": "FLOAT",
"ENUM": "STRING",
"SET": "STRING",
"IMAGE": "BINARY",
"INT": "NUMBER",
"INTEGER": "INTEGER",
"LONGTEXT": "VARCHAR",
"MEDIUMINT": "INTEGER",
"MEDIUMTEXT": "VARCHAR",
"MONEY": "NUMBER",
"NCHAR": "VARCHAR",
"NVARCHAR": "VARCHAR",
"NTEXT": "VARCHAR",
"NUMERIC": "NUMBER",
"REAL": "FLOAT",
"SMALLDATETIME": "DATETIME",
"SMALLINT": "NUMBER",
"SMALLMONEY": "NUMBER",
"TEXT": "VARCHAR",
"TIME": "TIME",
"TIMESTAMP": "TIMESTAMP_NTZ",
"TINYTEXT": "STRING",
"TINYINT": "NUMBER",
"VARCHAR": "VARCHAR",
"VARBINARY": "BINARY",
}