IssueWhen 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: