0 votes
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!
asked by

1 Answer

0 votes
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
answered by
836 questions
866 answers
809 comments
970 users