New table is not showing up in Database explorer

lmd · January 29, 2026, 7:07am

My self-hosted Metabase instance has a Starburst (Trino) connection to a Trino instance and is using Hive Metastore for metadata and MinIO as well as AWS S3 for storage.
I added a new table to the storage but it does not show up in the database explorer. I am able to query data from this new table manually using select * from hive.default.my_table. I already tried the “Sync database schema” and “Re-scan field values” buttons and discarding the saved field values from the admin settings for that connection but it does not make the tables show up despite them showing up as successful in the tasks log.

I double-checked that Metabase has all permissions in Trino. The table is not listed in the visibility settings either. How to make the new tables show up?

dwhitemv · January 29, 2026, 4:48pm

Are there any errors in the Metabase log after a sync?

lmd · February 2, 2026, 10:20am

Hi dwhitemw;

yes, here they are:

[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:36+01:00 INFO metabase.sync.util STARTING: Sync metadata for starburst Database 7 ''Data Lake'' (free: 0.16G, total: 0.71G, ratio: 0.22)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:36+01:00 WARN metabase.lib.normalize Error normalizing pMBQL: ["invalid type"]
{:value nil, :schema :metabase.lib.schema.metadata.fingerprint/fingerprint}

[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:36+01:00 DEBUG metabase.server.middleware.log GET /api/activity/recents 200 21ms (30 DB calls) App DB connections: 0/2 Jetty threads: 4/50 (3 idle, 0 queued) (134 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 1}
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:37+01:00 DEBUG metabase.server.middleware.log GET /api/bug-reporting/details 200 1ms (1 DB calls) App DB connections: 1/2 Jetty threads: 4/50 (3 idle, 0 queued) (134 total active threads) Queries in flight: 0 (0 queued) {:metabase-user-id 1}
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 ERROR metabase.sync.fetch-metadata Error while fetching metdata with 'db-metadata',java.sql.SQLException: Query failed (#20260202_095638_01456_givc7): Hive views are not supported: 'default.matomo_user_visits',	at io.trino.jdbc.ResultUtils.resultsException(ResultUtils.java:33),	at io.trino.jdbc.TrinoResultSet.getColumns(TrinoResultSet.java:143),	at io.trino.jdbc.TrinoResultSet.create(TrinoResultSet.java:49),	at io.trino.jdbc.TrinoStatement.internalExecute(TrinoStatement.java:276),	at io.trino.jdbc.TrinoStatement.execute(TrinoStatement.java:254),	at io.trino.jdbc.TrinoPreparedStatement.executeQuery(TrinoPreparedStatement.java:149),	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:743),	at metabase.driver.starburst$eval959$fn__960.invoke(starburst.clj:446),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.driver.starburst$describe_schema$fn__967.invoke(starburst.clj:469),	at clojure.core$filter$fn__5979$fn__5980.invoke(core.clj:2822),	at clojure.java.jdbc$init_reduce_rs.invokeStatic(jdbc.clj:1205),	at clojure.java.jdbc$init_reduce_rs.invoke(jdbc.clj:1197),	at clojure.java.jdbc$reducible_result_set_STAR_$reify__38893.reduce(jdbc.clj:1227),	at clojure.core$transduce.invokeStatic(core.clj:7025),	at clojure.core$into.invokeStatic(core.clj:7042),	at clojure.core$into.invoke(core.clj:7029),	at metabase.driver.starburst$describe_schema.invokeStatic(starburst.clj:466),	at metabase.driver.starburst$describe_schema.invoke(starburst.clj:460)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.util FINISHED: Sync metadata for starburst Database 7 ''Data Lake'' (1.8 s) (free: 0.09G, total: 0.71G, ratio: 0.13)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.util STARTING: Analyze data for starburst Database 7 ''Data Lake'' (free: 0.09G, total: 0.71G, ratio: 0.13)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 WARN metabase.sync.util Error in sync step Sync metadata for starburst Database 7 ''Data Lake'',java.sql.SQLException: Query failed (#20260202_095638_01456_givc7): Hive views are not supported: 'default.matomo_user_visits',	at io.trino.jdbc.ResultUtils.resultsException(ResultUtils.java:33),	at io.trino.jdbc.TrinoResultSet.getColumns(TrinoResultSet.java:143),	at io.trino.jdbc.TrinoResultSet.create(TrinoResultSet.java:49),	at io.trino.jdbc.TrinoStatement.internalExecute(TrinoStatement.java:276),	at io.trino.jdbc.TrinoStatement.execute(TrinoStatement.java:254),	at io.trino.jdbc.TrinoPreparedStatement.executeQuery(TrinoPreparedStatement.java:149),	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:743),	at metabase.driver.starburst$eval959$fn__960.invoke(starburst.clj:446),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.driver.starburst$describe_schema$fn__967.invoke(starburst.clj:469),	at clojure.core$filter$fn__5979$fn__5980.invoke(core.clj:2822),	at clojure.java.jdbc$init_reduce_rs.invokeStatic(jdbc.clj:1205),	at clojure.java.jdbc$init_reduce_rs.invoke(jdbc.clj:1197),	at clojure.java.jdbc$reducible_result_set_STAR_$reify__38893.reduce(jdbc.clj:1227),	at clojure.core$transduce.invokeStatic(core.clj:7025),	at clojure.core$into.invokeStatic(core.clj:7042),	at clojure.core$into.invoke(core.clj:7029),	at metabase.driver.starburst$describe_schema.invokeStatic(starburst.clj:466),	at metabase.driver.starburst$describe_schema.invoke(starburst.clj:460)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.util STARTING: step ''fingerprint-fields'' for starburst Database 7 ''Data Lake'' (free: 0.09G, total: 0.71G, ratio: 0.13)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze.fingerprint Fingerprinting 7 fields in table Table 872 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 WARN metabase.sync.util Error fingerprinting Table 872 ''default.REDACTED_TABLE_NAME'',clojure.lang.ExceptionInfo: Error executing query: Query failed (#20260202_095638_01457_givc7): line 2:8: Unexpected parameters (array(varchar), integer, integer) for function substring. Expected: substring(char(x), bigint), substring(char(x), bigint, bigint), substring(varchar(x), bigint), substring(varchar(x), bigint, bigint) {:driver :starburst, :sql ["-- Metabase accountID: c074efa2-9cdf-4e3b-8679-8aa3ff28d1ff" "SELECT" "  SUBSTRING(" "    \"default\".\"REDACTED_TABLE_NAME\".\"tag_lis...,	at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__96103$fn__96104.invoke(execute.clj:782),	at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__96103.invoke(execute.clj:779),	at metabase.driver.starburst$eval1016$fn__1017$fn__1018.invoke(starburst.clj:569),	at metabase.driver.sql_jdbc.execute$do_with_resolved_connection.invokeStatic(execute.clj:355),	at metabase.driver.sql_jdbc.execute$do_with_resolved_connection.invoke(execute.clj:335),	at metabase.driver.starburst$eval1016$fn__1017.invoke(starburst.clj:549),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:772),	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:761),	at metabase.driver.sql_jdbc$fn__98000.invokeStatic(sql_jdbc.clj:81),	at metabase.driver.sql_jdbc$fn__98000.invoke(sql_jdbc.clj:79),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:58),	at metabase.query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:43),	at metabase.query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:116),	at metabase.query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:105),	at metabase.query_processor.execute$run.invokeStatic(execute.clj:64),	at metabase.query_processor.execute$run.invoke(execute.clj:58),	at metabase.query_processor.middleware.enterprise$swap_destination_db_middleware$fn__68889.invoke(enterprise.clj:73)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [*****·············································] 😢   10% Table 843 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [**********········································] 😒   21% Table 870 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze.fingerprint Fingerprinting 3 fields in table Table 861 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 WARN metabase.sync.util Error fingerprinting Table 861 ''default.REDACTED_TABLE_NAME'',clojure.lang.ExceptionInfo: Error executing query: Query failed (#20260202_095638_01458_givc7): line 2:18: Column 'default.REDACTED_TABLE_NAME.notify_on' cannot be resolved {:driver :starburst, :sql ["-- Metabase accountID: c074efa2-9cdf-4e3b-8679-8aa3ff28d1ff" "SELECT" "  SUBSTRING(" "    \"default\".\"REDACTED_TABLE_NAME\".\"notify_on\"," "    1," "    1234" "  ) AS \"substring7912673\"," "  SUBSTRING(" "    \"default\".\"REDACTED_TABLE_NAME\".\"...,	at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__96103$fn__96104.invoke(execute.clj:782),	at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__96103.invoke(execute.clj:779),	at metabase.driver.starburst$eval1016$fn__1017$fn__1018.invoke(starburst.clj:569),	at metabase.driver.sql_jdbc.execute$do_with_resolved_connection.invokeStatic(execute.clj:355),	at metabase.driver.sql_jdbc.execute$do_with_resolved_connection.invoke(execute.clj:335),	at metabase.driver.starburst$eval1016$fn__1017.invoke(starburst.clj:549),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:772),	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:761),	at metabase.driver.sql_jdbc$fn__98000.invokeStatic(sql_jdbc.clj:81),	at metabase.driver.sql_jdbc$fn__98000.invoke(sql_jdbc.clj:79),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:58),	at metabase.query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:43),	at metabase.query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:116),	at metabase.query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:105),	at metabase.query_processor.execute$run.invokeStatic(execute.clj:64),	at metabase.query_processor.execute$run.invoke(execute.clj:58),	at metabase.query_processor.middleware.enterprise$swap_destination_db_middleware$fn__68889.invoke(enterprise.clj:73)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze.fingerprint Fingerprinting 2 fields in table Table 874 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 WARN metabase.sync.util Error fingerprinting Table 874 ''default.REDACTED_TABLE_NAME'',clojure.lang.ExceptionInfo: Error executing query: Query failed (#20260202_095638_01459_givc7): line 2:111: Unexpected parameters (array(varchar), integer, integer) for function substring. Expected: substring(char(x), bigint), substring(char(x), bigint, bigint), substring(varchar(x), bigint), substring(varchar(x), bigint, bigint) {:driver :starburst, :sql ["-- Metabase accountID: c074efa2-9cdf-4e3b-8679-8aa3ff28d1ff" "SELECT" "  \"default\".\"REDACTED_TABLE_NAME\".\"enable_email_noti...,	at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__96103$fn__96104.invoke(execute.clj:782),	at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__96103.invoke(execute.clj:779),	at metabase.driver.starburst$eval1016$fn__1017$fn__1018.invoke(starburst.clj:569),	at metabase.driver.sql_jdbc.execute$do_with_resolved_connection.invokeStatic(execute.clj:355),	at metabase.driver.sql_jdbc.execute$do_with_resolved_connection.invoke(execute.clj:335),	at metabase.driver.starburst$eval1016$fn__1017.invoke(starburst.clj:549),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:772),	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:761),	at metabase.driver.sql_jdbc$fn__98000.invokeStatic(sql_jdbc.clj:81),	at metabase.driver.sql_jdbc$fn__98000.invoke(sql_jdbc.clj:79),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:58),	at metabase.query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:43),	at metabase.query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:116),	at metabase.query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:105),	at metabase.query_processor.execute$run.invokeStatic(execute.clj:64),	at metabase.query_processor.execute$run.invoke(execute.clj:58),	at metabase.query_processor.middleware.enterprise$swap_destination_db_middleware$fn__68889.invoke(enterprise.clj:73)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze.fingerprint Fingerprinting 1 fields in table Table 879 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 WARN metabase.sync.util Error fingerprinting Table 879 ''default.REDACTED_TABLE_NAME'',clojure.lang.ExceptionInfo: Error executing query: Query failed (#20260202_095638_01460_givc7): line 2:8: Unexpected parameters (array(varchar), integer, integer) for function substring. Expected: substring(char(x), bigint), substring(char(x), bigint, bigint), substring(varchar(x), bigint), substring(varchar(x), bigint, bigint) {:driver :starburst, :sql ["-- Metabase accountID: c074efa2-9cdf-4e3b-8679-8aa3ff28d1ff" "SELECT" "  SUBSTRING(" "    \"default\".\"REDACTED_TABLE_NAME\".\...,	at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__96103$fn__96104.invoke(execute.clj:782),	at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__96103.invoke(execute.clj:779),	at metabase.driver.starburst$eval1016$fn__1017$fn__1018.invoke(starburst.clj:569),	at metabase.driver.sql_jdbc.execute$do_with_resolved_connection.invokeStatic(execute.clj:355),	at metabase.driver.sql_jdbc.execute$do_with_resolved_connection.invoke(execute.clj:335),	at metabase.driver.starburst$eval1016$fn__1017.invoke(starburst.clj:549),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:772),	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:761),	at metabase.driver.sql_jdbc$fn__98000.invokeStatic(sql_jdbc.clj:81),	at metabase.driver.sql_jdbc$fn__98000.invoke(sql_jdbc.clj:79),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:58),	at metabase.query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:43),	at metabase.query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:116),	at metabase.query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:105),	at metabase.query_processor.execute$run.invokeStatic(execute.clj:64),	at metabase.query_processor.execute$run.invoke(execute.clj:58),	at metabase.query_processor.middleware.enterprise$swap_destination_db_middleware$fn__68889.invoke(enterprise.clj:73)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [***************···································] 😕   31% Table 850 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze.fingerprint Fingerprinting 4 fields in table Table 842 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 WARN metabase.sync.util Error fingerprinting Table 842 ''default.REDACTED_TABLE_NAME'',clojure.lang.ExceptionInfo: Error executing query: Query failed (#20260202_095638_01461_givc7): line 2:176: Unexpected parameters (array(varchar), integer, integer) for function substring. Expected: substring(char(x), bigint), substring(char(x), bigint, bigint), substring(varchar(x), bigint), substring(varchar(x), bigint, bigint) {:driver :starburst, :sql ["-- Metabase accountID: c074efa2-9cdf-4e3b-8679-8aa3ff28d1ff" "SELECT" "  \"default\".\"REDACTED_TABLE_NAME\".\"merge_user\" AS ...,	at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__96103$fn__96104.invoke(execute.clj:782),	at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__96103.invoke(execute.clj:779),	at metabase.driver.starburst$eval1016$fn__1017$fn__1018.invoke(starburst.clj:569),	at metabase.driver.sql_jdbc.execute$do_with_resolved_connection.invokeStatic(execute.clj:355),	at metabase.driver.sql_jdbc.execute$do_with_resolved_connection.invoke(execute.clj:335),	at metabase.driver.starburst$eval1016$fn__1017.invoke(starburst.clj:549),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:772),	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:761),	at metabase.driver.sql_jdbc$fn__98000.invokeStatic(sql_jdbc.clj:81),	at metabase.driver.sql_jdbc$fn__98000.invoke(sql_jdbc.clj:79),	at clojure.lang.MultiFn.invoke(MultiFn.java:244),	at metabase.query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:58),	at metabase.query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:43),	at metabase.query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:116),	at metabase.query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:105),	at metabase.query_processor.execute$run.invokeStatic(execute.clj:64),	at metabase.query_processor.execute$run.invoke(execute.clj:58),	at metabase.query_processor.middleware.enterprise$swap_destination_db_middleware$fn__68889.invoke(enterprise.clj:73)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.util FINISHED: step ''fingerprint-fields'' for starburst Database 7 ''Data Lake'' (142.0 ms) (free: 0.47G, total: 0.71G, ratio: 0.67)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.util STARTING: step ''classify-fields'' for starburst Database 7 ''Data Lake'' (free: 0.47G, total: 0.71G, ratio: 0.67)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze classify-fields Analyzed [********************······························] 😐   42% Table 871 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze classify-fields Analyzed [**************************························] 😬   52% Table 873 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze classify-fields Analyzed [*******************************···················] 😏   63% Table 876 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.util FINISHED: step ''classify-fields'' for starburst Database 7 ''Data Lake'' (25.9 ms) (free: 0.46G, total: 0.71G, ratio: 0.65)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.util STARTING: step ''classify-tables'' for starburst Database 7 ''Data Lake'' (free: 0.46G, total: 0.71G, ratio: 0.65)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze classify-tables Analyzed [*****************************************·········] 😊   83% Table 849 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze classify-tables Analyzed [************************************··············] 😋   73% Table 839 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.analyze classify-tables Analyzed [**********************************************····] 😍   94% Table 882 ''default.REDACTED_TABLE_NAME''
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.util FINISHED: step ''classify-tables'' for starburst Database 7 ''Data Lake'' (6.0 ms) (free: 0.46G, total: 0.71G, ratio: 0.65)
[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 INFO metabase.sync.util FINISHED: Analyze data for starburst Database 7 ''Data Lake'' (180.6 ms) (free: 0.46G, total: 0.71G, ratio: 0.65)

randolph · February 2, 2026, 10:57am

The 5th line of the logs shows the issue:

[d1c7d18c-baef-427f-a5cf-be250c1f2943] 2026-02-02T10:56:38+01:00 ERROR metabase.sync.fetch-metadata Error while fetching metdata with 'db-metadata',java.sql.SQLException: Query failed (#20260202_095638_01456_givc7): Hive views are not supported: 'default.matomo_user_visits',	at

Specifically, it mentions this:
Hive views are not supported: 'default.matomo_user_visits'

My knowledge of Hive is limited, but you may check along the lines of how to enable Hive view support in Trino/Starburst Hive catalog

lmd · February 2, 2026, 2:24pm

Hi randolph, thank you for that observation.
The table that is actually a view is not a problem. I have a table that comes from an MSSQL DB which does not show up in the explorer, nor in the log. There are more examples of tables that originate from e.g. Postgres.
Basically, the tables which were part of the data lake before Metabase was set up, showed up, but any tables added to the lake afterwards don't. Does this sound familiar?
Furthermore, I can't explain errors like

Unexpected parameters (array(varchar), integer, integer) for function substring. Expected: substring(char(x), bigint), substring(char(x), bigint, bigint), substring(varchar(x), bigint), substring(varchar(x), bigint, bigint)

From my research, it means that Metabase does not know the actual schema of the table and it needs to be synched, but that is what I'm trying to do.

dwhitemv · February 2, 2026, 8:54pm

Thanks for providing the logs, it answers a lot of questions. For the record, what version of Trino are you running?

For the unsupported Hive view, the easy answer may be to wrap it in a Trino view that does a simple SELECT * FROM default.matomo_user_visits, or equivalent query. That should expose the data in a SQL-friendly way and avoid the limitation in the JDBC driver.

For the SUBSTRING errors, that seems more like a Metabase bug, it should be casting the arguments to a signature of substring supported in the standard catalog. What it's trying to do is get the fully-qualified table name limited to 1024 characters.

It should be work-around-able by defining a new version of substring with the argument types coming from Metabase that casts them to a supported type and calls substring again, but on the other hand that shouldn't be necessary.

We will have to set up a reproduction case for that so a bug can be filed. In case its a passthrough bug from the underlying database, what database is backing the tables that throw the error on the substring call?

Last thing that needs to be worked out is Column 'default.REDACTED_TABLE_NAME.notify_on' cannot be resolved. My assumption is that the table being scanned there has a problematic view defined with a column that has since been removed. Check the definition for that table and make sure it is complete and correct.

dwhitemv · February 3, 2026, 5:20am

I set up a simple Trino 479 instance, adding my local PostgreSQL database as a datasource, and was able to connect to and sync it okay from Metabase 58.4, so there’s no overt problems using current versions of things.

lmd · February 3, 2026, 11:44am

Thank you for your effort so far. The following are Docker Compose files for Metabase, Trino, and Hive Metastore. Each file is deployed on an individual host. I hope this files make it easier to reproduce the issue:

services:
  postgres:
    image: postgres:16
    container_name: hivemetastore-db
    environment:
      POSTGRES_PASSWORD: REDACTED
    volumes:
      - path_to_hive_metastore_data/:/var/lib/postgresql/data
      - path_to_hive_metastore_logs/:/var/log/psql/
    ports:
      - "5432:5432"
    networks:
      - app_network
    restart: unless-stopped

  hive-metastore:
    image: apache/hive:3.1.3
    container_name: hive-metastore
    user: root
    environment:
      SERVICE_NAME: metastore
      DB_DRIVER: postgres
      SERVICE_OPTS: "-Djavax.jdo.option.ConnectionDriverName=org.postgresql.Driver -Djavax.jdo.option.ConnectionURL=jdbc:postgresql://postgres:5432/metastore_db -Djavax.jdo.option.ConnectionUserName=REDACTED -Djavax.jdo.option.ConnectionPassword=REDACTED"
      IS_RESUME: "true" # needs to be commented when starting a new metastore or rebuild
    ports:
      - "9083:9083"
    depends_on:
      - postgres
    volumes:
      - /path_to/postgresql-42.5.1.jar:/opt/hive/lib/postgres.jar
      - /path_to/hive-site.xml:/opt/hive/conf/hive-site.xml
      - /path_to/core-site.xml:/opt/hadoop/etc/hadoop/core-site.xml
      - /path_to/hive-env.sh:/opt/hive/conf/hive-env.sh
    networks:
      - app_network
    entrypoint: >
      /bin/bash -c "
      /opt/hive/bin/schematool -initSchema -dbType postgres || /opt/hive/bin/schematool -upgradeSchema -dbType postgres;
      /opt/hive/bin/hive --service metastore"
    restart: unless-stopped

  datalake-trino:
    container_name: datalake-trino
    image: INTERNAL_MIRROR/trino:476
    labels:
      - traefik.enable=true
      - traefik.http.routers.datalake-trino.rule=Host(`REDACTED`)
      - traefik.http.services.datalake-trino.loadbalancer.server.port=8080
    depends_on:
      - hive-metastore
    volumes:
      - path_to/catalog:/etc/trino/catalog
      - path_to/config.properties:/etc/trino/config.properties:ro
      - path_to/node.properties:/etc/trino/node.properties:ro
      - path_to/jvm.config:/etc/trino/jvm.config:ro
      - path_to/access-control.properties:/etc/trino/access-control.properties:ro
      - path_to/log.properties:/etc/trino/log.properties:ro
      - path_to/password-authenticator.properties:/etc/trino/password-authenticator.properties:ro
      - path_to/ranger-trino-audit.xml:/etc/trino/ranger-trino-audit.xml:ro
      - path_to/ranger-trino-security.xml:/etc/trino/ranger-trino-security.xml:ro
      - path_to/password.db:/etc/trino/password.db:ro
    restart: unless-stopped
    networks:
      - app_network
      - proxy

networks:
  app_network:
  proxy:
    external: true

services:
  traefik:
    image: INTERNAL_MIRROR/traefik:latest
    restart: unless-stopped
    container_name: "traefik"
    security_opt:
      - no-new-privileges:true
    command:
      # EntryPoints
      - "--entrypoints.web.address=:80"
      - "--entrypoints.web.http.redirections.entrypoint.to=websecure"
      - "--entrypoints.web.http.redirections.entrypoint.scheme=https"
      - "--entrypoints.web.http.redirections.entrypoint.permanent=true"
      - "--entrypoints.websecure.address=:443"
      - "--entrypoints.websecure.http.tls=true"
      # Attach the static configuration tls.yaml file that contains the tls configuration settings
      - "--providers.file.filename=/dynamic-config/tls.yaml"
      # Providers
      - "--providers.docker=true"
      - "--providers.docker.exposedbydefault=false"
      - "--providers.docker.network=metabase_metaproxy"
      # API & Dashboard
      - "--api.dashboard=false"
      - "--api.insecure=false"
      # Observability
      - "--log.level=INFO"
      - "--accesslog=true"
      - "--metrics.prometheus=false"
    ports:
      - "80:80"
      - "443:443"
    volumes:
      - /var/run/docker.sock:/var/run/docker.sock:ro
      - path_to/certs:/certs:ro
      - path_to/dynamic-config:/dynamic-config:ro
    networks:
      - metaproxy
  metabase:
    image: INTERNAL_MIRROR/metabase:latest #v0.56.6
    container_name: metabase
    hostname: metabase
    labels:
      - "traefik.enable=true"
      - "traefik.http.routers.metabase.rule=Host(`REDACTED`)"
      - "traefik.http.routers.metabase.entrypoints=websecure"
      - "traefik.http.routers.metabase.tls=true"
      - "traefik.http.services.metabase.loadbalancer.server.port=3000"
    volumes:
      - /dev/urandom:/dev/random:ro
    environment:
      MB_DB_TYPE: postgres
      MB_DB_DBNAME: REDACTED
      MB_DB_PORT: 5432
      MB_DB_USER: REDACTED
      MB_DB_PASS: REDACTED
      MB_DB_HOST: postgres
    networks:
      - metanet
      - metaproxy
    healthcheck:
      test: curl --fail -I http://localhost:3000/api/health || exit 1
      interval: 15s
      timeout: 5s
      retries: 5
  postgres:
    image: INTERNAL_MIRROR/postgres:15.13
    container_name: postgres
    hostname: postgres
    environment:
      POSTGRES_USER: REDACTED
      POSTGRES_DB: REDACTED
      POSTGRES_PASSWORD: REDACTED
    volumes:
    - path_to/db-data:/var/lib/postgresql/data/
    networks:
      - metanet
  postgres-uploads:
    image: INTERNAL_MIRROR/postgres:15.13
    container_name: postgres-uploads
    hostname: postgres-uploads
    environment:
      POSTGRES_USER: metabase
      POSTGRES_DB: metabaseuploads
      POSTGRES_PASSWORD: REDACTED
    volumes:
    - upload-db-data:/var/lib/postgresql/data/
    networks:
      - metanet
networks:
  metanet:
    driver: bridge
  metaproxy:
volumes:
  db-data:
  upload-db-data:

lmd · February 3, 2026, 11:51am

2 of the occurrences come from Postgres databases and 2 from a Gitlab instance. The data is synced using Airbyte, columns which Airbyte added to the source data are removed using Airflow, and the data is written to the S3 storage of a Nutanix instance.