Snowflake Data Type Conversions
This section covers data type conversions between the Trifacta Application and Snowflake databases.
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 Type | Supported | Alteryx Data Type |
|---|---|---|
NUMBER | Y | Integer |
DECIMAL | Y | Integer |
NUMERIC | Y | Integer |
INT | Y | Integer |
INTEGER | Y | Integer |
BIGINT | Y | Integer |
SMALLINT | Y | Integer |
FLOAT | Y | Decimal |
FLOAT4 | Y | Decimal |
FLOAT8 | Y | Decimal |
DOUBLE | Y | Decimal |
DOUBLE_PRECISION | Y | Decimal |
REAL | Y | Decimal |
VARCHAR | Y | String |
CHAR | Y | String |
CHARACTER | Y | String |
STRING | Y | String |
TEXT | Y | String |
BINARY | Y | String |
VARBINARY | Y | String |
BOOLEAN | Y | Bool |
DATE | Y | String |
DATETIME | Y | String |
TIME | Y | String |
TIMESTAMP | Y | String |
TIMESTAMP_TZ | Y | Datetime |
TIMESTAMP_LTZ | Y 1) | Datetime |
TIMESTAMP_NTZ | Y 2) | Datetime |
VARIANT | N | |
OBJECT | N | |
ARRAY | N |
Notes:
Convert to Datetime using local timezone of the Snowflake connector
Convert to Datetime using UTC
Write/Publish
Alteryx Data Type | Supported | Snowflake Type | Notes |
|---|---|---|---|
Array | N | ||
Bool | Y | BOOLEAN | |
Date | Y | TIMESTAMP | See below. |
Datetime | Y | TIMESTAMP | |
Time | Y | TIME | |
Float | Y | FLOAT | |
Integer | Y | BIGINT | |
Map | N | ||
String | Y | VARCHAR |
Notes on Date publishing:
Note
Alteryx Date columns can be published to existing Snowflake columns of Date, Datetime, and String type.
When Dates are published to Snowflake, the following date formats are supported. In some cases, missing data is inserted into the output value.
Alteryx date format | Snowflake date format |
|---|---|
yy-dd-mm | yy-dd-mm |
yy-mm-dd | yy-mm-dd |
dd-mm-yy | dd-mm-yy |
mm-dd-yy | mm-dd-yy |
mm-yy | mm-yy |
dd-mm | 1970-dd-mm |
mm-dd | 1970-mm-dd |
mm-yy | mm-yy-01 |
On publication, all dates are written in the following format:
yyyy-mm-dd.No other date formats are supported for writing to Snowflake as date values.