Page tree

Release 6.8.2


Contents:

   

NOTE: The Alteryx® data types listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

Source TypeSupported

Alteryx Data Type

NUMBER

YInteger
DECIMALYInteger
NUMERICYInteger
INTYInteger
INTEGERYInteger
BIGINTYInteger
SMALLINTYInteger
FLOATYDecimal
FLOAT4YDecimal
FLOAT8YDecimal
DOUBLEYDecimal
DOUBLE_PRECISIONYDecimal
REALYDecimal
VARCHARYString
CHARYString
CHARACTERYString
STRINGYString
TEXTYString
BINARYYString
VARBINARYYString
BOOLEANYBool
DATEYString
DATETIMEYString
TIMEYString
TIMESTAMPYString
TIMESTAMP_TZY

Datetime

TIMESTAMP_LTZY 1)

Datetime

TIMESTAMP_NTZ Y 2)

Datetime

VARIANTN
OBJECTN
ARRAYN

Notes:

  1. Convert to Datetime using local timezone of the Snowflake connector
  2. Convert to Datetime using UTC

Write/Publish

Alteryx Data Type

SupportedSnowflake TypeNotes

Array

N

BoolYBOOLEAN
DateYTIMESTAMP

NOTE: Date values without time information from Designer Cloud Enterprise Edition are written to Snowflake as Datetime values. This is a known issue.

DatetimeYTIMESTAMP
TimeYTIME
FloatYFLOAT
IntegerYBIGINT
MapN

StringYVARCHAR

This page has no comments.