Skip to main content

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:

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

  2. 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.