Extracting 10,000,000 rows from Redshift takes 1000+ seconds (Linux RHEL AmazonRedshiftODBC-64-bit-1.4.65.1000-1.x86_64). On windows desktop with the same equivalent driver, it takes about 200 seconds.
What am I doing wrong? Is there any special configuration?
P.S. We're really trying to extract 180 million rows, it's just quicker to test with 10 million rows.
Hi @Jeff Strauss
As per my experience, slowness is the default behaviour for example if you run the query in amazon redshift supposed takes 10 minutes and the same query if you run on Tableau desktop it will take around 20 minutes based on the data size your speed will depend. As [per my experience please optimize your queries or create a view or store procedure to optimize your extract refresh. For more information please follow the below white paper.
https://www.tableau.com/learn/whitepapers/optimize-tableau-redshift-better-deployment
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions.
Thank you.
Kaustubh
(TABLEAU AMBASSADOR 22-23)
