Type Conversions
This section provides information on type conversions in Cloud Portal.
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 Cloud Portal 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 Cloud Portal:
The application maps the internal Alteryx 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
Item | Description |
---|---|
This section covers data type conversions between the Cloud Portal and the Avro file format. | |
This section covers data type conversions between the Cloud Portal and DB2 databases. | |
This section covers data type conversions between the Cloud Portal and Oracle databases. | |
This section covers data type conversions between the Cloud Portal and MySQL databases. | |
This section covers data type conversions between the Cloud Portal and the Parquet file format. | |
This section covers data type conversions between the Cloud Portal and PostgreSQL databases. | |
This section covers data type conversions between the Cloud Portal and Redshift. | |
This section covers data type conversions between the Cloud Portal and Snowflake databases. | |
This section covers data type conversions between the Cloud Portal and Salesforce. | |
This section covers data type conversions between the Cloud Portal and SQL Server databases. | |
This section covers data type conversions between the Cloud Portal and Teradata databases. | |
This section covers data type conversions between the Cloud Portal and SharePoint. |