Skip to main content

SQL DW Data Type Conversions

This section covers data type conversions between the Trifacta Application and SQL DW datastores.

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 Data Type

Supported

Alteryx Data Type

Notes

INT

Y

Integer

TINYINT

Y

Integer

SMALLINT

Y

Integer

BIGINT

Y

Integer

Note

The Designer Cloud Powered by Trifacta platform may infer bigint columns containing very large or very small values as String data type. If needed, you can disable type inference for individual schematized sources. For more information, seeImport Data Page.

FLOAT

Y

Float

REAL

Y

Float

BIT

Y

Bool

SMALLMONEY

Y

String

MONEY

Y

String

DECIMAL

Y

Float

NUMERIC

Y

String

DATETIMEOFFSET

Y

String

TIME

Y

String

DATE

Y

String

DATETIME

Y

String

DATETIME2

Y

String

SMALLDATETIME

Y

String

CHAR

Y

String

VARCHAR

Y

String

NCHAR

Y

String

NVARCHAR

Y

String

SYSNAME

Y

String

BINARY

Y

String

VARBINARY

Y

String

UNIQUEIDENTIFIER

Y

String

TIMESTAMP

N

GEOGRAPHY

N

GEOMETRY

N

HIERARCHYID

N

IMAGE

N

TEXT

N

NTEXT

N

XML

N

CURSOR

N

ROWVERSION

N

SQL_VARIANT

N

Write/Publish

Create new table

Alteryx Data Type

SQL DW Data Type

Notes

String

VARCHAR

Integer

BIGINT

Note

The Designer Cloud Powered by Trifacta platform may infer Integer columns containing very large or very small values as String data type. Before you publish, you should verify that your columns containing extreme values are interpreted as Integer type. You can import a target schema to assist in lining up your columns with the expected target. For more information, seeOverview of Target Schema Mapping.

Float

FLOAT

Bool

BIT

Datetime

DATETIME2

If a time-only value is published as an append to a pre-defined DATETIME2 column, then the output column is prepended with 1900-01-01.

Datetime (with time value only)

TIME

If a value is published as an append to a pre-defined TIME column, then any date information is dropped from the output.

Note

The platform publishes to Timestamp columns only for append operations to pre-existing tables.

Datetime

VARCHAR

If a Datetime value is published as an append to a pre-defined VARCHAR column, then the output column contains the string value of whatever appears in the Transformer page.

When you publish results from a job through the Publishing dialog to SQL DW, all Datetime column values are written as String type.

Map

VARCHAR

Array

VARCHAR

Date

VARCHAR

All Other Data Types

VARCHAR

Append to existing table

If you are publishing to a pre-existing table, the following data type conversions apply:

  • Columns: Alteryx data types

  • Rows: Target table data types

In any table cell, a Y indicates that the append operation for that data type mapping is supported.

String

Integer

Datetime

Bool

Float

Map

Array

VARCHAR

Y

Y

Y

Y

Y

Y

Y

NVARCHAR

Y

Y

Y

Y

Y

Y

Y

CHAR

Y

Y

Y

Y

Y

Y

Y

NCHAR

Y

Y

Y

Y

Y

Y

Y

TINYINT

SMALLINT

INT

BIGINT

Y

DATETIME2

Y

TIME

Y

BIT

Y

FLOAT

Y

Y

REAL

Y

Y

DECIMAL

Y

Y

In this section: