Contents:
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 Designer Cloud 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.
Export
On export from the Designer Cloud application:
- 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
Avro Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and the Avro file format.
DB2 Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and DB2 databases.
Hive Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and Hive.
Oracle Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and Oracle databases.
MySQL Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and MySQL databases.
Parquet Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and the Parquet file format.
Postgres Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and PostgreSQL databases.
Redshift Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and Redshift.
Snowflake Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and Snowflake databases.
AWS Glue Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and AWS Glue.
Salesforce Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and Salesforce.
SQL Server Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and SQL Server databases.
SQL DW Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and SQL DW datastores.
Databricks Tables Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and Databricks Tables.
Tableau Hyper Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and Tableau Hyper format.
Teradata Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and Teradata databases.
SharePoint Data Type Conversions
This section covers data type conversions between the Designer Cloud® application and SharePoint.
This page has no comments.