Hey Dan -
Tableau employee here. We have a bunch of customers on Redshift, and nearly all of them are doing quite well. The size of the dataset is actually irrelevant because of Redshift's performance characteristics. The only folks I know who are having any problem are those trying to import lots of data from Redshift to Tableau -- because of a problem with Amazon' driver.
If you do a quick search of the forums, you should see some folks talking about Redshift.
Thanks, Russell! Will do.
Quick question... if the size of the dataset is irrelevant, does this mean Tableau works differently than other BI apps and if so, how?
The size of the dataset is irrelevant because Tableau itself isn’t generally doing the “heavy lifting” when it comes to answering a question – Redshift is. When you ask “show me the sum of sales per region” across 10 billion rows – the “real work” goes on at the database level (Redshift). Redshift simply a few, highly aggregated “answer rows” to us, like:
We just plot those 4 things.
Got it. Thanks, Russell. So the row limit only affects extracts and not
the actual size of datasets being queried.
Any news on the connector issues folks seemed to be having?
On Thu, Sep 5, 2013 at 3:10 PM, Russell Christopher <
Someone just posted that Amazon has come up with an initial fix. Good news!
I can't connect to Redshift on 8.1. It works on my 8.0. Any ideas on where I can get the fix?
I am sorry to hear you are having problems. A few questions for you:
1) What version of 8.0 were you running before upgrading to 8.1?
2) Are you receiving any specific error messages?
Tableau Software, Product Manager
1) Version 8 works fine for me. My version is 8.0.4.
2) With 8.1, on the data connection dialog, I get as far as step 4. It's able to to the handshake and authorization all the way up to step 4, but on step 5 nothing shows up when I try to pull the drop-down to pick a schema. There are no error messages, just the fact that nothing is populated in step 5.
The core issue is that cursors are not currently supported on single-node Redshift instances (only multi-node instances). Tableau 8.1 and 8.0.5 uses cursors by default to enumerate schemas, which is why single node instances are missing them.
Amazon is adding support of cursors on single-node Redshift instances, but we do not have an exact ETA yet.
If you would like to discuss further, please reach out to me directly via email: email@example.com
Cursor support has been added for single-node Redshift instances. Please upgrade to the latest Tableau maintenance release 8.1.3 (or 8.0.7) and any single-node cursor issues should be resolved.
Product Manager, Tableau Software
Great news for us prototyping on a single node. Thanks for the update.