Does Metabase allow for selecting different Snowflake warehouses based on the query?

1

Does Metabase allow for selecting different Snowflake warehouses based on the query?

I'm interested in selecting different warehouses based on the query computation requirements, in order to minimize Snowflake costs. Bonus points if this is autodetected.

Thank you in advance!

1 Like
2

Hey, any update on this?
I checked the Metabase documentation - Snowflake Connection and Roadmap, and it seems that we don’t have anything for this.

Even when we try to change the warehouse in a Metabase question:

USE WAREHOUSE REPORTING_S;
SELECT 1;

It’s not possible, as Metabase only accepts one statement.

Has anyone discovered any workaround for this?

Thanks

3

We don't have this feature, please create a feature request in our github issue tracker since it seems very specific

1 Like
4

Thanks @Luiggi. I'll create it.

5

The feature request was created Enable Per-Query Warehouse Selection for Snowflake Connections · Issue #48992 · metabase/metabase · GitHub.