Metabase can query all of the tables in all schemas, but stops syncing after just a few of the schemas are scanned, so the Data Browser is missing most of the schemas. I looked at sys_query_history and don't see any query errors for the metabase login, it just like stops at a certain view after successfully querying it. I tried querying the views/table after it using the metabase login and the 1<>1 permissions query and it works fine.
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.20.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.20.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.20.1+1",
"os.name": "Linux",
"os.version": "4.14.313-235.533.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"redshift",
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.10"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.4"
}
},
"run-mode": "prod",
"version": {
"date": "2023-10-11",
"tag": "v0.47.4",
"branch": "?",
"hash": "c96dc65"
},
"settings": {
"report-timezone": "UTC"
}
}
}
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
at com.amazon.redshift.jdbc.RedshiftStatementImpl.checkClosed(RedshiftStatementImpl.java:827)
at com.amazon.redshift.jdbc.RedshiftPreparedStatement.setString(RedshiftPreparedStatement.java:419)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setString(NewProxyPreparedStatement.java:431)
at metabase.driver.redshift$reducible_schemas_with_usage_permissions$reify__132078$fn__132079.invoke(redshift.clj:346)
at clojure.core$filter$fn__5958$fn__5959.invoke(core.clj:2822)
at clojure.core$completing$fn__8528.invoke(core.clj:6931)
at clojure.core$filter$fn__5958$fn__5959.invoke(core.clj:2823)
at clojure.core$filter$fn__5958$fn__5959.invoke(core.clj:2823)
at clojure.core$filter$fn__5958$fn__5959.invoke(core.clj:2823)
at clojure.core$take_while$fn__5982$fn__5983.invoke(core.clj:2918)
at clojure.core.protocols$fn__8249.invokeStatic(protocols.clj:168)
at clojure.core.protocols$fn__8249.invoke(protocols.clj:124)
at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6886)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.driver.sql_jdbc.sync.common$reducible_results$reify__88257.reduce(common.clj:39)
at clojure.core$transduce.invokeStatic(core.clj:6946)
at clojure.core.Eduction.reduce(core.clj:7750)
at clojure.core$transduce.invokeStatic(core.clj:6946)
at clojure.core.Eduction.reduce(core.clj:7750)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.driver.redshift$reducible_schemas_with_usage_permissions$reify__132078.reduce(redshift.clj:340)
at clojure.core$transduce.invokeStatic(core.clj:6946)
at clojure.core.Eduction.reduce(core.clj:7750)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$into.invokeStatic(core.clj:6958)
at clojure.core$into.invoke(core.clj:6950)
at metabase.driver.sql_jdbc.sync.describe_database$fn__88794$describe_database__88795$fn__88796.invoke(describe_database.clj:177)
at metabase.driver.redshift$fn__131991$fn__131993.invoke(redshift.clj:149)
at metabase.driver.sql_jdbc.execute$fn__80800$do_with_resolved_connection__80801.invoke(execute.clj:334)
at clojure.lang.AFn.applyToHelper(AFn.java:165)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at malli.core$_instrument$fn__13254.doInvoke(core.cljc:2526)
at clojure.lang.RestFn.invoke(RestFn.java:457)
at metabase.driver.redshift$fn__131991.invokeStatic(redshift.clj:137)
at metabase.driver.redshift$fn__131991.invoke(redshift.clj:135)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.driver.sql_jdbc.sync.describe_database$fn__88794$describe_database__88795.invoke(describe_database.clj:163)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at malli.core$_instrument$fn__13254.doInvoke(core.cljc:2526)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at metabase.driver.sql_jdbc$fn__115913.invokeStatic(sql_jdbc.clj:84)
at metabase.driver.sql_jdbc$fn__115913.invoke(sql_jdbc.clj:82)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.sync.fetch_metadata$fn__97141$db_metadata__97146$fn__97147.invoke(fetch_metadata.clj:15)
at metabase.sync.fetch_metadata$fn__97141$db_metadata__97146.invoke(fetch_metadata.clj:12)
at metabase.sync.sync_metadata$fn__99560$sync_db_metadata_BANG___99565$fn__99566.invoke(sync_metadata.clj:58)
at metabase.sync.sync_metadata$fn__99560$sync_db_metadata_BANG___99565.invoke(sync_metadata.clj:55)
at metabase.api.database$fn__108479$fn__108480.invoke(database.clj:983)
at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
...
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 ERROR metabase.driver.redshift Error checking schema permissions
com.amazon.redshift.util.RedshiftException: This statement has been closed.
at com.amazon.redshift.jdbc.RedshiftStatementImpl.checkClosed(RedshiftStatementImpl.java:827)
at com.amazon.redshift.jdbc.RedshiftPreparedStatement.setString(RedshiftPreparedStatement.java:419)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setString(NewProxyPreparedStatement.java:431)
at metabase.driver.redshift$reducible_schemas_with_usage_permissions$reify__132078$fn__132079.invoke(redshift.clj:346)
at clojure.core$filter$fn__5958$fn__5959.invoke(core.clj:2822)
at clojure.core$completing$fn__8528.invoke(core.clj:6931)
at clojure.core$filter$fn__5958$fn__5959.invoke(core.clj:2823)
at clojure.core$filter$fn__5958$fn__5959.invoke(core.clj:2823)
at clojure.core$filter$fn__5958$fn__5959.invoke(core.clj:2823)
at clojure.core$take_while$fn__5982$fn__5983.invoke(core.clj:2918)
at clojure.core.protocols$fn__8249.invokeStatic(protocols.clj:168)
at clojure.core.protocols$fn__8249.invoke(protocols.clj:124)
at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6886)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.driver.sql_jdbc.sync.common$reducible_results$reify__88257.reduce(common.clj:39)
at clojure.core$transduce.invokeStatic(core.clj:6946)
at clojure.core.Eduction.reduce(core.clj:7750)
at clojure.core$transduce.invokeStatic(core.clj:6946)
at clojure.core.Eduction.reduce(core.clj:7750)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.driver.redshift$reducible_schemas_with_usage_permissions$reify__132078.reduce(redshift.clj:340)
at clojure.core$transduce.invokeStatic(core.clj:6946)
at clojure.core.Eduction.reduce(core.clj:7750)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$into.invokeStatic(core.clj:6958)
at clojure.core$into.invoke(core.clj:6950)
at metabase.driver.sql_jdbc.sync.describe_database$fn__88794$describe_database__88795$fn__88796.invoke(describe_database.clj:177)
at metabase.driver.redshift$fn__131991$fn__131993.invoke(redshift.clj:149)
at metabase.driver.sql_jdbc.execute$fn__80800$do_with_resolved_connection__80801.invoke(execute.clj:334)
at clojure.lang.AFn.applyToHelper(AFn.java:165)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at malli.core$_instrument$fn__13254.doInvoke(core.cljc:2526)
at clojure.lang.RestFn.invoke(RestFn.java:457)
at metabase.driver.redshift$fn__131991.invokeStatic(redshift.clj:137)
at metabase.driver.redshift$fn__131991.invoke(redshift.clj:135)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.driver.sql_jdbc.sync.describe_database$fn__88794$describe_database__88795.invoke(describe_database.clj:163)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at malli.core$_instrument$fn__13254.doInvoke(core.cljc:2526)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at metabase.driver.sql_jdbc$fn__115913.invokeStatic(sql_jdbc.clj:84)
at metabase.driver.sql_jdbc$fn__115913.invoke(sql_jdbc.clj:82)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.sync.fetch_metadata$fn__97141$db_metadata__97146$fn__97147.invoke(fetch_metadata.clj:15)
at metabase.sync.fetch_metadata$fn__97141$db_metadata__97146.invoke(fetch_metadata.clj:12)
at metabase.sync.sync_metadata$fn__99560$sync_db_metadata_BANG___99565$fn__99566.invoke(sync_metadata.clj:58)
at metabase.sync.sync_metadata$fn__99560$sync_db_metadata_BANG___99565.invoke(sync_metadata.clj:55)
at metabase.api.database$fn__108479$fn__108480.invoke(database.clj:983)
at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 INFO metabase.sync.util STARTING: Sync metadata for redshift Database 10 'redshift'
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 INFO metabase.sync.util STARTING: step 'sync-dbms-version' for redshift Database 10 'redshift'
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 INFO metabase.sync.util FINISHED: step 'sync-dbms-version' for redshift Database 10 'redshift' (5.8 ms)
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for redshift Database 10 'redshift'
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for redshift Database 10 'redshift' (17.5 ms)
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 INFO metabase.sync.util STARTING: step 'sync-tables' for redshift Database 10 'redshift'
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 INFO metabase.sync.sync-metadata.tables Found new tables: (Table 'ad_hoc.ad_stats_view' Table 'analytics.net_acquisition_email_summaries')
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 INFO metabase.sync.sync-metadata.tables Updating description for tables: (Table 'ad_hoc.ad_stats_view' Table 'analytics.net_acquisition_email_summaries')
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for redshift Database 10 'redshift' (478.9 ms)
[5d7f68d4-2049-4167-8d61-41c0f46c5690] 2023-10-16T10:54:01-04:00 INFO metabase.sync.util STARTING: step 'sync-fields' for redshift Database 10 'redshift'