AWS Aurora RDS for MySQL has a feature known as Parallel Query which will improve latencies for Analytics Workloads.
- https://aws.amazon.com/rds/aurora/parallel-query/
- https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-mysql-parallel-query.html
We can force Aurora to use Parallel Query for a session using
SET SESSION aurora_pq_force = on;
which will ensure that it is used for all the queries run in that session.
Is there a way to ensure that all queries going from Metabase use this setting by configuring anywhere.
I could not even use this as a separate SQL statement while building dashboards.