Open topic with navigation

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake 6.3.0

# XSD Datatype Mapping

Snowflake supports many alias and synonyms for datatypes. The following table shows how those datatypes are mapped to XSD data types in the plug-in.

Snowflake Column Definition | XSD Type
--- | ---
Number(N,10) | integer
Number(N,2) | decimal
Decimal(N,2) | decimal
Numeric(N,2) | decimal
Int | integer
Integer | integer
Bigint | integer
Smallint | integer
Double | double
Float | double
Double Precision | double
Real | double
Varchar | string
Varchar(N) | string
Char | string
Char(N) | string
Character | string
Character(N) | string
String | string
String(N) | string
Text | string
Text(N) | string
Binary | base64Binary
Binary(N) | base64Binary
varbinary | base64Binary
Boolean | boolean
Date | date
Time | time
Timestamp | dateTime
Timestamp_LTZ | dateTime
Timestamp_NTZ | dateTime
Timestamp_TZ | dateTime
Variant | anyType
Object | anyType
ARRAY | anyType

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake

Copyright © 2020-2024. Cloud Software Group, Inc. All Rights Reserved.