How can i disable this only group by feature

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'data.arbitrages.revenue' which is not functionally dependent on columns in
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Hi @Tonyloi
It seems like it's some special MySQL configuration you're using:

I don't know how you're hitting this problem. Include more details.

I'm trying to sum and group revenues with the same address i only wish to group by the address

I would love to know how I can disable the MySQL's only_full_group_by feature in metabase please

@Tonyloi Metabase does not set that session variable. It is defined on your MySQL server.
I've never seen this error before, so I guess you have a very special MySQL configuration.