NOTE: The Trifacta® 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? | Trifacta 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
Trifacta 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 Trifacta 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.
This page has no comments.