KNOWLEDGE BASE

Error "this Functionality Is A Part Of The Athena Preview Features And Should Be Run In The Workgroup Named Amazonathenapreviewfunctionality Upon Publishing


Published: 25 May 2020
Last Modified Date: 26 May 2020

Issue

When publishing Athena data source with user defined function in custom query, a Sign in dialog box to connect to data source popped up even though Embedded password for Authentication method had been set. Re-entering the access key ID and secret access key made no difference. Closing the dialog box would allow the data source to be published with the message "Data source <data-source-name> successfully published, but Tableau could not connect to the published data source. The workbook will continue to use the local data source..." would appear.

Error found in Tableau Server log:
[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. This functionality is a part of the Athena Preview features and should be run in the workgroup named AmazonAthenaPreviewFunctionality. [Execution ID not available]

The entry below has been already added to the JDBC properties file (athena.properties for Athena) on Tableau Desktop and Tableau Desktop is able to connect successfully to the data source with user defined function present in custom query:

workgroup=AmazonAthenaPreviewFunctionality

Environment

  • Tableau Server 2020.2.0
  • CentOS 7
  • Amazon Athena

Resolution

To resolve this issue, copy the athena.properties file from the working Tableau Desktop machine to all Tableau Server nodes in the following directory: 
  • /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources/ for Linux
  • tabsvc/vizqlserver/Datasources for Windows

Cause

The entry below needs to be present in the JDBC properties file (athena.properties for Athena) but athena.properties was not present on the affected Tableau Server:

workgroup=AmazonAthenaPreviewFunctionality

Additional Information

Pre-requisites:

1.  If not already done so, ensure an Athena workgroup named AmazonAthenaPreviewFunctionality and join that workgroup:

Querying with User Defined Functions (Preview)
https://docs.amazonaws.cn/en_us/athena/latest/ug/querying-udf.html

Relevant excerpt:

AmazonAthenaPreviewFunctionality workgroup – To use this feature in preview, you must create an Athena workgroup named AmazonAthenaPreviewFunctionality and join that workgroup. For more information, see Managing Workgroups.

2.  Ensure the entry below has been added to the JDBC properties file (athena.properties for Athena) on Tableau Desktop and that Tableau Desktop able to connect successfully to the data source with user defined function present in custom query:

workgroup=AmazonAthenaPreviewFunctionality

For more details on customizing JDBC Connections Using a Properties File:

https://community.tableau.com/docs/DOC-17978
Did this article resolve the issue?