Skip to main content

Table Import Settings

When you edit settings for a selected table in the Import Data page, the following settings are displayed.

You can edit any additional or optional settings for an individual dataset. Perform the following:

  1. Click Edit Settings from the card for an individual dataset in the right panel. The dialog box is displayed.

  2. In the dialog box, select the required options and modify the settings.

Infer column data types

You can choose whether or not to apply the Alteryx Analytics Cloud type inference to table data imported from a database.

  • In the preview panel, you can see the data type that is to be applied after the dataset is imported. This data type may change depending on whether column data type inference is enabled or disabled for the dataset.

  • To enable the Alteryx Analytics Cloud type inference, select the Infer column data types checkbox.

Tipp

To see the effects of the Alteryx Analytics Cloud type inference, you can toggle the checkbox and review data type listed at the top of individual columns. To override an individual column's data type, click the data type name and select a new value.

For more information, see Disable Type Inference.

You can configure the default use of type inference at the individual connection level. For more information, see Create Connection Window.