Skip to main content

SQL Server Data Type Conversions

This section covers data type conversions between the Trifacta Application and SQL Server 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 Data Type

Supported?

Alteryx Data Type

Bigint

Y

Integer

BIGINT IDENTITY

Y

Integer

Binary

Y

String (Base64)

Bit

Y

Bool

Char

Y

String

Cursor

N

Date

Y

Date

Datetime

Y

Date

Datetime2

Y

Date

Datetimeoffset

Y

String

Decimal

Y

Integer/Decimal

DECIMAL IDENTITY

Y

Integer

Float

Y

Decimal

GEOGRAPHY

Y

String

GEOMETRY

Y

String

HIERARCHYID

Y

String

Image

Y

String

Int

Y

Integer

INT IDENTITY

Y

Integer

Money

Y

Decimal

Nchar

Y

String

Ntext

Y

String

Numeric

Y

Integer/Decimal

NUMERIC IDENTITY

Y

Integer

Nvarchar

Y

String

Nvarchar(max)

Y

String

Real

Y

Decimal

Smalldatetime

Y

Date

Smallint

Y

Integer

SMALLINT IDENTITY

Y

Integer

Smallmoney

Y

Decimal

Sql_variant

N

Table

N

Text

Y

String

Time

Y

String

Timestamp

Y

String

Tinyint

Y

Integer

TINYINT IDENTITY

Y

Integer

Uniqueidentifier

Y

String

Varbinary

Y

String (Base64)

Varbinary(max)

Y

String (Base64)

Varchar

Y

String

Varchar(max)

Y

String

Xml

Y

String

Write/Publish

Alteryx Data Type

SQL Server Column Type

Notes

Bool

BIT

VARCHAR(256)

Integer

BIGINT

INT

SMALLINT

DECIMAL

VARCHAR(256)

String

VARCHAR(256)

Datetime

DATETIME

TIMESTAMP

VARCHAR(256)

Timestamp

TIME

VARCHAR(256)

Float

FLOAT

DECIMAL

NUMERIC

VARCHAR(256)

Map

VARCHAR(256)

Array

VARCHAR(256)

Note

If you are appending to an existing table where a column's Alteryx data type is not mapped to the column data type in the target table, a validation error is thrown, as the platform writes unmapped types as String data type.