Forum Discussion

IAM's avatar
IAM
Helper III
3 years ago
Solved

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?
Need Help
  • AnkitKukreja's avatar
    AnkitKukreja
    3 years ago

    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.

     

AnkitKukreja's avatar
AnkitKukreja
Super User
3 years ago

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.