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:
Click Edit Settings from the card for an individual dataset in the right panel. The dialog box is displayed.
In the dialog box, select the required options and modify the settings.
Infer column data types
You can choose whether or not to apply Designer Cloud Powered by Trifacta Enterprise Edition 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 Designer Cloud Powered by Trifacta Enterprise Edition type inference, select the Infer column data types checkbox.
Tip
To see the effects of Designer Cloud Powered by Trifacta Enterprise Editiontype 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.
You can configure the default use of type inference at the individual connection level. For more information, see Create Connection Window.
For schematized sources that do not require connections, such as uploaded Avro files, the default setting is determined by the global setting for initial type inference. For more information, see Configure Type Inference.