I have tableau desktop. I am creating a report using 5 tables out of 5 table 2 tables are big. These tables are joined and applied filter. extract creation taking a long time (6-7 hours and still running). big tables have 100+ columns, I use only 12 columns to build my report. Now, there is an option to use custom SQL which take less time for creating extract but then I cannot use tableau to its full potential. any suggestion is welcome. I am looking for the name of the column I can choose for creating the extract.

Thank you

Honey Asin