Selectively Import Columns when connecting to a table

[Eric]

We have multiple tables that are easily over 200 columns per table, is there a way to quickly select which columns to bring in? Right now we are importing everything and then manually deleting one at a time, which seems inefficient. Thanks!

[Clément_Stenac]

Hi,

It is not possible to select columns when creating a "SQL Table" dataset.

You can create a "SQL Query" dataset instead. An important note is that a SQL Query dataset cannot benefit from the "In-database" engine for visual recipes, and cannot be used as input for a SQL recipe (basically, you should almost only use it as input of a prepare recipe).

See https://doc.dataiku.com/dss/latest/connecting/sql_datasets.html for more information