Issue

A query to Snowflake has been created and is used as live data source in Tableau Desktop.
When the data source is published to Tableau Server and used as the data source of the workbook the following error will occur:

An error occurred while communicating with data source 'MDM Overview (2)'

Error Code:B9F09DDB

An error occurred while communicating with the Snowflake data source 'MDM Overview (local copy)'

SQL compilation error: error line 40 at position 23

'"t7"."$temp1_import1"' in select clause is neither an aggregate nor in the group by clause.

DataServiceFailure

When the data source is used as an extract there is no issue.