Source
SQL Compilation Error (GROUP BY) - Code compatibility with MySQL
ISSUE: Some customers might face a compilation error due to columns that are not used in any aggregations or listed in the group by columns. Error: '<column_name>' in select clause is neither an aggregate nor in the group by clause.
Viewing MySQL data in Snowflake
The connector replicates data to the destination database, which was defined while setting up the connector and calling PUBLIC.