Forum Discussion
Do not open all columns from SQL table
Hi all,
I have a SQL connection, this gives 518 columns and 23.000 rows. I only need about 40 columns..
What is the best way to avoid importing the 480 columns I do not need?
Hi! IAM
There are 2 approaches that I follow and possible in the same order of choice if you can.
1) Get a view created for your table with the required column and then directly connect to that view. By creating a view you can also handle some of the transformations at the source level.
2) You can use a select statement with the column names and connect to the same table.
I hope it would make sense why to choose the 1st approach.
1 Reply
Hi! IAM
There are 2 approaches that I follow and possible in the same order of choice if you can.
1) Get a view created for your table with the required column and then directly connect to that view. By creating a view you can also handle some of the transformations at the source level.
2) You can use a select statement with the column names and connect to the same table.
I hope it would make sense why to choose the 1st approach.