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
When a BigQuery data type is imported, its data type is remapped according to the following table.
NOTE: When type inference is disabled on a BigQuery data source, time-based data types are imported as String type. This is a known issue.
Tip: Data precision may be lost during conversion. You may want to generate min and max values and compute significant digits for values in your BigQuery tables and then compute the same in Dataprep by Trifacta.
| Source Data Type | Supported? | Trifacta Data Type | Notes |
|---|---|---|---|
| String | Y | String | |
| Bytes | Y | String | |
| Integer | Y | Integer | |
| Float | Y | Decimal | |
| Boolean | Y | Boolean | |
| Timestamp | Y | Datetime | Millisecond and microsecond precision in BigQuery is dropped during the import process. |
| Date | Y | Datetime | If imported data contains microsecond precision, values are handled differently depending on the area of the product:
|
| Time | Y | Datetime | |
| Datetime | Y | Datetime | |
| Array | Y | Array | |
| Record | Y | Object |
Publish/Write
NOTE: Trifacta data types not listed here are written as string types in the target database.
Trifacta Data Type | BigQuery Data Type | Notes |
|---|---|---|
| String | String | |
| Integer | Integer | |
| Decimal | Float | |
| Boolean | Boolean | |
| Datetime | Datetime | Target data type is based on the underlying data. Time zone information is lost. |
| Datetime (time data only) | Time | |
| Array | String | |
| Object | String |
This page has no comments.