On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.
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.