KNOWLEDGE BASE

Athena JDBC error AA76601F: Validation error detected: Value null at workGroup failed to satisfy constraint. Member must not be null When creating Custom SQL


Published: 12 May 2021
Last Modified Date: 07 Jun 2021

Issue

Athena JDBC error: "Validation error detected: Value null at workGroup failed to satisfy constraint. Member must not be null" when creating Custom SQL or convert table to Custom SQL

Error occurs with latest Amazon Athena JDBC drivers AthenaJDBC42.jar and AthenaJDBC41.jar V 2.21.

Athena Error Custom SQL

 

Environment

  • Tableau Desktop
  • Amazon Athena JDBC driver 2.21

Resolution

Workarounds:

Option 1
Pass explicitly the parameter WorkGroup=primary through a athena.properties file
a - Create the athena.properties file with the following content:
WorkGroup=primary
b - Save the file on "C:\Users\<User>\Documents\My Tableau Repository\Datasources"
c - Reopen Tableau Desktop
  • Athena.properties file attached

Option 2
Replace the current .jar file to a previous version of the Athena JDBC driver on "C:\Program Files\Tableau\Drivers"
+ Attached the version AthenaJDBC42.jar 2.16 as a workaround.

Cause

Athena driver v2.21 is not passing the default “primary” workgroup to Athena which causes this issue
 
Did this article resolve the issue?