Issue
When connecting to Amazon Redshift data using the Postgres connector, a custom SQL statement joined to an identical custom SQL statement will result in only null values for all fields in the right side of the join.
Last Modified Date: 30 Jun 2020
Environment
- Tableau Desktop 2020.2.0
- Amazon Redshift connection using the PostgreSQL connector
Resolution
Option 1Use the native Redshift connector for the data connection
Option 2
Give the join fields different aliases in the SQL statements
Option 3
Combine the two custom SQL statements into a single statement that also includes the join
Cause
This issue may be related to the driver used since it does not occur when Amazon Redshift connector is used instead of Postgres connector.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials