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 
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. For information on how data types are inferred, see Overview of the Type System.
Export
On export from the :
- The application maps the internal
to the explicit type listed in the appropriate page in this section. - Unmapped types are converted to the equivalent of strings.
Tip: You can import a target schema to assist in lining up your columns with the expected target. For more information, see Overview of RapidTarget. |
For more information on the data types that are supported within the , see Supported Data Types.