Page tree


Contents:

   

Contents:


This section provides information on type conversions in Dataprep by Trifacta application .

Import

When data is imported:

  • Supported data types from the source are converted to corresponding data types supported by the application, based upon the conversions listed in this section.
  • Types that are not supported but are recognized by the application are converted to String types.
  • Data for types that cannot be read from the source due to technical reasons are converted to null values on import.

Type Inference

By default, the  Dataprep by Trifacta application  applies type inference for imported data. The application attempts to infer a column's appropriate data type in the application based on a review of the first lines in the sample and how those lines are interpreted by the type system.

Type inference can be disabled for individual datasets. For more information, see Disable Type Inference.

Export

On export from the Dataprep by Trifacta application :

  • The application maps the internal Dataprep by Trifacta data type to the explicit type listed in the appropriate page in this section.
  • Unmapped types are converted to the equivalent of strings.


Type Conversions

ItemDescription
Avro Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and the Avro file format.
BigQuery Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and BigQuery.
DB2 Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and DB2 databases.
Oracle Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and Oracle databases.
MySQL Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and MySQL databases.
Parquet Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and the Parquet file format.
Postgres Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and PostgreSQL databases.
Salesforce Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and Salesforce.
SQL Server Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and SQL Server databases.
Teradata Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and Teradata databases.
SharePoint Data Type Conversions This section covers data type conversions between the Dataprep by Trifacta application and SharePoint.

This page has no comments.