Which driver are you using specifically? Are you using the postgres or redshift driver?
Thanks for your reply.
I am using the Postgres drivers that are available in drivers link for tableau.
Please let me know how i can get rid of this issue.
Thanks & Regards,
I would need the log lines from your tabprotosrv log files (within Documents/My Tableay Repositiory) to be sure; but I believe Tableau is creating a temp table within the pg_internal schema. I believe this schema is now visible from redshift - previously redshift would hide it when enumerating schemas.
To see if this is the issue, try disabling temp table creation by modifying the connection capabilities:
We are looking at what looks like a similar issue and we should have a more concrete solution in the near future.
Thanks for your Suggestion.
I am unable to share you the logs.
can you please provide your personal ID to share it.
[first letter of my first name][my last name] at tableau.com
Make sure to include tabprotosrv and regular log files. Also; I would like to know the version of tableau you are at.
FYI; I'm not part of tableau support - I'm an engineer - but this particular issue interests me.
We are facing the same problem as Lakhan right now.
Our observations show that the error occurs when there is a view on view join in a custom query.
This is a simple example of such query:
from our_schema.Purchases p1
join our_schema.Purchases p2 ON p2.ID = p1.ID
The error is [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: Operation not allowed on schema "pg_internal" DETAIL:
We are experiencing the same issue as well. Custom SQL queries that used to work in Tableau desktop are no longer working. However, the same custom SQL queries still work in other non-Tableau tools.
The queries immediately result in "[Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: Operation not allowed on schema "pg_internal" DETAIL:"
Can confirm have this same issue. Tried tableau desktop 9.0 and 9.1.2 both experience same result. Looks like there was a AWS Redshift cluster update on the 30th Jan which could have changed expected behaviours
Redshift Cluster Version: 1.0.1026
Seems to only affect when building a new report and connecting to Redshift as data source from scratch, existing workbooks seem ok so far
In meantime Postgres driver option is providing a work around to get connected in.
Make sure you are using postgres driver 9.03.400; rather than the most recent 9.05.100. There is still some work to improve the quality of the new postgres driver.
For the general problem, we should have a fix in 9.1.7 and 9.2.5; and we are looking at other releases as needed.
Thanks John and jordan for the info.
Can you please provide the link to latest postgres drivers to install?
We are also experiencing the same issue with custom queries that worked perfectly fine prior to upgrading from 9.1 to 9.2.2. I am on an earlier version of the Postgres driver (9.03.0300) so the proposed solution of reverting to an older driver doesn't apply here. Anyone have any further suggestions? The data sources seem to refresh successfully once published to Tableau server. This is causing major roadblocks on projects for us.
Thanks John. It appears that adding a TDC file setting
CAP_CREATE_TEMP_TABLES=No seems to have worked. I named the file redshift_config.tdc and placed it in the 'My Tableau Repository\Datasources' folder. Here are the exact contents of the file:
<connection-customization class='redshift' version='9.0' enabled='true'>
<vendor name='redshift' />
<driver name='redshift' />
<customization name='CAP_CREATE_TEMP_TABLES Off' value='CAP_CREATE_TEMP_TABLES=No' />
Update: Actually, I have spoken too soon. The problem isn't resolved.... I am still seeing the error when trying to create an extract, but not when querying live...
1) Use the Postgres 9.03.0400 driver (downloadable here: http://www.postgresql.org/ftp/odbc/versions/msi/) Don't forget to uninstall all other Postgres drivers.
2) Disable temp table creation via Redshift or Postgres by using one of the two TDC files attached. Please place these two files (see attached) in your Documents\My Tableau Repository\Datasources folder and restart Tableau Desktop. If you choose this option, please be sure to remove the TDC files after upgrading to fully fixed version in the future.