I would like to ask you where are you publishing your datasource ?
If yes then in which machine is it ?
If it is in different machine Maybe you need to download the driver on that machine.
Thank you for your response. Coming to your questions:
Yes I am publishing my workbook onto tableau server.
Now, coming onto the drivers, if it had been an issue. Then how could my extract refreshes when I hide few columns.
I have in total 30 columns in my redshift table, which I am connecting to tableau.
When I hide 10-15 of the unused columns(which are not used in my visualization). The extract gets created faster, which is expected and even my extract schedule gets refreshed at the scheduled time.
But when I create an extract with all 30 columns and schedule it, the refresh fails.