Disable Type Inference
When the Designer Cloud Powered by Trifacta platform creates an imported dataset from a schematized source, the product applies its own type inferencing to the columns of the imported data. Type inferencing may be reapplied during some operations, such as the creation of samples or when data reshaping transformations are applied in the Transformer page.
If preferred, you can disable this type inferencing on the columns of your imported dataset. When the data is imported, the original types from the source system remain. Any types that do not have a corresponding match with the Alteryx data types must be manually typed in the application.
Methods of disabling:
Column data typing is applied to schematized sources in one of three ways:
Globally
Per-connection type inference settings override the global setting.
Per-file type inference settings override both global and per-connection settings.
For more information on applying global or per-connection type inference settings, see Configure Type Inference.
You can use the following steps to disable type inference applied to a specific file during the import process.
Tip
For imported datasets from relational sources, you can identify in Flow View whether type inferencing has been applied to the dataset. When the dataset is selected in Flow View, locate the Type Inference entry in the right panel.
Tip
If you have already imported the dataset and need to change this setting, you can re-import the source and change the settings. In any locations where the previously imported version of this dataset is used, you can update references to use this new version. this newly imported version.
Steps:
After you have selected or specified the relational table to import in the Import Data page, click Edit Settings for the dataset card in the right panel.
Deselect the Infer column data types checkbox.
Continue the import process.