Selectively Import Columns when connecting to a table
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!
Re: Selectively Import Columns when connecting to a table
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