How do I set a schema for metabase tables？

ColinShen · March 28, 2025, 12:39am

I'm using postgresql. I see metabase tables were created in public schema. How can I change it?

TonyC · March 28, 2025, 9:49am

You can't cause our migrations are expecting the public schema but there is a feature request open for that:

github.com/metabase/metabase

Allow Metabase to work in other schemas other than public in the application database

opened 12:01AM - 18 Jan 24 UTC

paoliniluis

Type:New Feature Operation/ Operation/Database Migrations

**Is your feature request related to a problem? Please describe.** Seems that w…e don't allow Metabase to work on any other schemas other than public due to a problem with migrations If you use a connection string with currentSchema=some_other_schema (https://jdbc.postgresql.org/documentation/use/) Metabase will always try to initialize in the public schema ``` aused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v00.00-000::qnkhuat: metabase-postgres | Reason: liquibase.exception.DatabaseException: ERROR: schema "public" does not exist [Failed SQL: (0) -- metabase-postgres | -- Name: citext; Type: EXTENSION; Schema: -; Owner: - metabase-postgres | -- metabase-postgres | metabase-postgres | CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public] metabase-postgres | at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:123) metabase-postgres | at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:102) metabase-postgres | at liquibase.Scope.lambda$child$0(Scope.java:194) metabase-postgres | at liquibase.Scope.child(Scope.java:203) metabase-postgres | at liquibase.Scope.child(Scope.java:193) metabase-postgres | at liquibase.Scope.child(Scope.java:172) metabase-postgres | at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:99) metabase-postgres | at liquibase.command.CommandScope.execute(CommandScope.java:212) metabase-postgres | ... 53 more metabase-postgres | Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v00.00-000::qnkhuat: metabase-postgres | Reason: liquibase.exception.DatabaseException: ERROR: schema "public" does not exist [Failed SQL: (0) -- metabase-postgres | -- Name: citext; Type: EXTENSION; Schema: -; Owner: - metabase-postgres | -- metabase-postgres | metabase-postgres | CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public] ``` **Describe the solution you'd like** Allow Metabase to be able to live in other schemas other than public **Describe alternatives you've considered** None currently **How important is this feature to you?** Found this while going through other bugs **Additional context** NA