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
990 questions
1,023 answers
1,075 comments
2,830 users

©Dataiku 2012-2018 - Privacy Policy