Schemas can be directly queried but not showing up in UI, sync not working

Get Help
1

We are self-hosting Metabase in an AWS container connected to a Snowflake database.

Starting two weeks ago—if we query the database directly, everything works as normal. However, any kind of UI navigation—whether it's "Browse Data" or adding a filter to a SQL card—returns only tables from one of our schemas, "analytics". Metabase does not recognize/we cannot navigate to any other schema, and Metabase doesn't seem to recognize that the tables it can display are within the 'analytics' schema. It's as if Metabase's Snowflake user ran USE SCHEMA [database].analytics and is unable to use anything outside of it.

I found a few other threads over the past few years with this issue, but was not able to resolve them with the advice given there. I've hit all the buttons I'm supposed to: drop values, re-scan, sync. Nothing changes.

We added the exact same database as a new connection with the exact same credentials, and it works just fine. We also restarted the container hosting Metabase and nothing changed.

Here is our debug info:

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.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.21+9",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.21",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.21+9",
    "os.name": "Linux",
    "os.version": "5.10.201-191.748.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "snowflake",
      "postgres",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "13.10"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.6.0"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2023-12-19",
      "tag": "v0.48.1",
      "hash": "a8302d4"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

Here are the relevant logs:

[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:36-06:00 INFO metabase.sync.util STARTING: Cache field values in snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:36-06:00 INFO metabase.sync.util STARTING: step 'delete-expired-advanced-field-values' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:36-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 158.1 µs (0 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (18 idle, 0 queued) (132 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:37-06:00 INFO metabase.sync.util FINISHED: step 'delete-expired-advanced-field-values' for snowflake Database 5 'Uno Health Analytics' (1.8 s)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:37-06:00 INFO metabase.sync.util STARTING: step 'update-field-values' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:45-06:00 DEBUG metabase.server.middleware.log POST /api/database/5/sync_schema 200 1.9 s (3 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (18 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:46-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 182.3 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (134 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:47-06:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 4.3 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:47-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 122.4 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:47-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 124.4 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:48-06:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 16.5 ms (4 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (16 idle, 0 queued) (134 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:48-06:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 23.6 ms (10 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (16 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:48-06:00 DEBUG metabase.server.middleware.log GET /api/bookmark 200 3.8 ms (1 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (15 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:48-06:00 DEBUG metabase.server.middleware.log GET /api/database 200 27.5 ms (3 DB calls) App DB connections: 5/15 Jetty threads: 7/50 (14 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:48-06:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 48.5 ms (2 DB calls) App DB connections: 4/15 Jetty threads: 6/50 (14 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:48-06:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 97.0 ms (5 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (15 idle, 0 queued) (134 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:48-06:00 DEBUG metabase.server.middleware.log GET /api/search 200 124.1 ms (5 DB calls) App DB connections: 2/15 Jetty threads: 4/50 (16 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 INFO metabase.sync.util STARTING: Sync metadata for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 INFO metabase.sync.util STARTING: step 'sync-dbms-version' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 INFO metabase.sync.util FINISHED: step 'sync-dbms-version' for snowflake Database 5 'Uno Health Analytics' (35.8 ms)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for snowflake Database 5 'Uno Health Analytics' (135.8 ms)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 INFO metabase.sync.util STARTING: step 'sync-tables' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 INFO metabase.sync.sync-metadata.sync-timezone :snowflake database 5 default timezone is "America/Los_Angeles"
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for snowflake Database 5 'Uno Health Analytics' (7.1 ms)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 INFO metabase.sync.util STARTING: step 'sync-fields' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 WARN metabase.util.malli.fn Invalid input - Please report this as an issue on Github: ["invalid type"] {:type :metabase.util.malli.fn/invalid-input, :error {:schema :map, :value nil, :errors ({:path [], :in [], :schema :map, :value nil, :type :malli.core/invalid-type})}, :humanized [invalid type], :schema :map, :value nil, :fn-name metabase.query-processor.util/query-hash}
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 WARN metabase.util.malli.fn Invalid input - Please report this as an issue on Github: ["invalid type"] {:type :metabase.util.malli.fn/invalid-input, :error {:schema :map, :value nil, :errors ({:path [], :in [], :schema :map, :value nil, :type :malli.core/invalid-type})}, :humanized [invalid type], :schema :map, :value nil, :fn-name metabase.query-processor.util/select-keys-for-hashing}
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 WARN metabase.util.malli.fn Invalid input - Please report this as an issue on Github: ["invalid type"] {:type :metabase.util.malli.fn/invalid-input, :error {:schema :map, :value nil, :errors ({:path [], :in [], :schema :map, :value nil, :type :malli.core/invalid-type})}, :humanized [invalid type], :schema :map, :value nil, :fn-name metabase.query-processor.util/query-hash}
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 WARN metabase.util.malli.fn Invalid input - Please report this as an issue on Github: ["invalid type"] {:type :metabase.util.malli.fn/invalid-input, :error {:schema :map, :value nil, :errors ({:path [], :in [], :schema :map, :value nil, :type :malli.core/invalid-type})}, :humanized [invalid type], :schema :map, :value nil, :fn-name metabase.query-processor.util/select-keys-for-hashing}
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 DEBUG metabase.server.middleware.log GET /api/dashboard/186 200 2.2 s (49 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (16 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued); snowflake DB 5 connections: 2/3 (0 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 DEBUG metabase.server.middleware.log GET /api/collection/335 200 61.6 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (16 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 DEBUG metabase.server.middleware.log GET /api/pulse/form_input 200 4.1 ms (1 DB calls) App DB connections: 1/15 Jetty threads: 6/50 (15 idle, 0 queued) (136 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:50-06:00 DEBUG metabase.server.middleware.log GET /api/collection/229 200 34.5 ms (5 DB calls) App DB connections: 4/15 Jetty threads: 10/50 (11 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:51-06:00 DEBUG metabase.server.middleware.log GET /api/field/3966 200 60.7 ms (6 DB calls) App DB connections: 14/15 Jetty threads: 27/50 (0 idle, 0 queued) (144 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:51-06:00 DEBUG metabase.server.middleware.log GET /api/field/7557 200 99.2 ms (6 DB calls) App DB connections: 14/15 Jetty threads: 25/50 (0 idle, 0 queued) (143 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:51-06:00 DEBUG metabase.server.middleware.log GET /api/field/3967 200 131.7 ms (6 DB calls) App DB connections: 15/15 Jetty threads: 25/50 (0 idle, 0 queued) (142 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2234/card/2260/query 202 [ASYNC: completed] 1.1 s (17 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (22 idle, 0 queued) (162 total active threads) Queries in flight: 19 (0 queued); snowflake DB 5 connections: 1/3 (0 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2239/card/2266/query 202 [ASYNC: completed] 1.2 s (17 DB calls) App DB connections: 6/15 Jetty threads: 3/50 (22 idle, 0 queued) (164 total active threads) Queries in flight: 18 (0 queued); snowflake DB 5 connections: 3/3 (1 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2232/card/2257/query 202 [ASYNC: completed] 1.4 s (17 DB calls) App DB connections: 6/15 Jetty threads: 3/50 (22 idle, 0 queued) (167 total active threads) Queries in flight: 17 (0 queued); snowflake DB 5 connections: 2/3 (0 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2204/card/2243/query 202 [ASYNC: completed] 1.4 s (17 DB calls) App DB connections: 5/15 Jetty threads: 3/50 (22 idle, 0 queued) (168 total active threads) Queries in flight: 16 (0 queued); snowflake DB 5 connections: 3/3 (0 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2242/card/2269/query 202 [ASYNC: completed] 1.3 s (17 DB calls) App DB connections: 5/15 Jetty threads: 3/50 (22 idle, 0 queued) (169 total active threads) Queries in flight: 15 (0 queued); snowflake DB 5 connections: 6/6 (9 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2380/card/2237/query 202 [ASYNC: completed] 1.5 s (17 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (22 idle, 0 queued) (168 total active threads) Queries in flight: 14 (0 queued); snowflake DB 5 connections: 3/3 (6 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2205/card/2244/query 202 [ASYNC: completed] 1.4 s (17 DB calls) App DB connections: 3/15 Jetty threads: 3/50 (22 idle, 0 queued) (170 total active threads) Queries in flight: 13 (0 queued); snowflake DB 5 connections: 6/6 (8 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2240/card/2267/query 202 [ASYNC: completed] 1.5 s (17 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (22 idle, 0 queued) (170 total active threads) Queries in flight: 12 (0 queued); snowflake DB 5 connections: 3/3 (5 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2235/card/2261/query 202 [ASYNC: completed] 1.5 s (17 DB calls) App DB connections: 3/15 Jetty threads: 3/50 (22 idle, 0 queued) (167 total active threads) Queries in flight: 11 (0 queued); snowflake DB 5 connections: 7/7 (11 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2233/card/2259/query 202 [ASYNC: completed] 1.5 s (17 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (22 idle, 0 queued) (167 total active threads) Queries in flight: 10 (0 queued); snowflake DB 5 connections: 6/6 (7 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2376/card/2476/query 202 [ASYNC: completed] 1.5 s (17 DB calls) App DB connections: 4/15 Jetty threads: 3/50 (22 idle, 0 queued) (166 total active threads) Queries in flight: 9 (0 queued); snowflake DB 5 connections: 6/6 (10 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2522/card/2614/query 202 [ASYNC: completed] 1.4 s (17 DB calls) App DB connections: 4/15 Jetty threads: 3/50 (22 idle, 0 queued) (166 total active threads) Queries in flight: 8 (0 queued); snowflake DB 5 connections: 6/6 (11 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2369/card/2467/query 202 [ASYNC: completed] 1.5 s (17 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (22 idle, 0 queued) (164 total active threads) Queries in flight: 7 (0 queued); snowflake DB 5 connections: 3/3 (7 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2236/card/2262/query 202 [ASYNC: completed] 1.6 s (17 DB calls) App DB connections: 3/15 Jetty threads: 3/50 (22 idle, 0 queued) (163 total active threads) Queries in flight: 6 (0 queued); snowflake DB 5 connections: 6/6 (5 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2237/card/2264/query 202 [ASYNC: completed] 1.6 s (17 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (22 idle, 0 queued) (162 total active threads) Queries in flight: 5 (0 queued); snowflake DB 5 connections: 9/9 (10 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2238/card/2265/query 202 [ASYNC: completed] 1.7 s (17 DB calls) App DB connections: 3/15 Jetty threads: 3/50 (22 idle, 0 queued) (158 total active threads) Queries in flight: 4 (0 queued); snowflake DB 5 connections: 3/3 (3 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2271/card/2334/query 202 [ASYNC: completed] 1.7 s (22 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (22 idle, 0 queued) (158 total active threads) Queries in flight: 3 (0 queued); snowflake DB 5 connections: 12/12 (8 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2525/card/2617/query 202 [ASYNC: completed] 1.7 s (17 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (22 idle, 0 queued) (159 total active threads) Queries in flight: 2 (0 queued); snowflake DB 5 connections: 6/6 (6 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:52-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2366/card/2464/query 202 [ASYNC: completed] 1.8 s (17 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (22 idle, 0 queued) (159 total active threads) Queries in flight: 1 (0 queued); snowflake DB 5 connections: 3/3 (2 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:53-06:00 DEBUG metabase.server.middleware.log POST /api/dashboard/186/dashcard/2521/card/2613/query 202 [ASYNC: completed] 2.0 s (22 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (22 idle, 0 queued) (159 total active threads) Queries in flight: 0 (0 queued); snowflake DB 5 connections: 12/12 (9 threads blocked)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:43:56-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 160.7 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (22 idle, 0 queued) (158 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:04-06:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for snowflake Database 5 'Uno Health Analytics' (13.5 s)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:04-06:00 INFO metabase.sync.util STARTING: step 'sync-fks' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:06-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 174.8 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (22 idle, 0 queued) (157 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:07-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 176.3 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (22 idle, 0 queued) (158 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:07-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 183.7 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (21 idle, 0 queued) (158 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:09-06:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for snowflake Database 5 'Uno Health Analytics' (5.8 s)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:09-06:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for snowflake Database 5 'Uno Health Analytics' (288.6 µs)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:09-06:00 INFO metabase.sync.util FINISHED: step 'sync-table-privileges' for snowflake Database 5 'Uno Health Analytics' (122.9 µs)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:09-06:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:09-06:00 INFO metabase.sync.util STARTING: step 'sync-table-privileges' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:09-06:00 INFO metabase.sync.util FINISHED: Sync metadata for snowflake Database 5 'Uno Health Analytics' (19.5 s)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:09-06:00 INFO metabase.sync.util STARTING: Analyze data for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:09-06:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:09-06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [*****·············································] 😢   10% Table 540 'ANALYTICS.MCMD_HIST_INCR_TEST'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [**********········································] 😞   20% Table 406 'ANALYTICS.EMPLOYEES_ENGAGEMENT'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [***************···································] 😕   30% Table 586 'ANALYTICS.PORTAL_FUNNEL'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for snowflake Database 5 'Uno Health Analytics' (720.9 ms)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.util STARTING: step 'classify-fields' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.analyze classify-fields Analyzed [********************······························] 😐   41% Table 528 'ANALYTICS.TEMP_OLD_DUPES'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.analyze classify-fields Analyzed [*************************·························] 😬   51% Table 372 'ANALYTICS.PPFU_MAIN'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.analyze classify-fields Analyzed [******************************····················] 😌   61% Table 566 'ANALYTICS.EL_BONUS_DUAL_ENROLLS'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for snowflake Database 5 'Uno Health Analytics' (131.7 ms)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.util STARTING: step 'classify-tables' for snowflake Database 5 'Uno Health Analytics'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.analyze classify-tables Analyzed [***********************************···············] 😋   71% Table 470 'ANALYTICS.MEMBER_ENV_RETURNED_TIMELINE'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.analyze classify-tables Analyzed [****************************************··········] 😊   81% Table 297 'ANALYTICS.WORKDAYS'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.analyze classify-tables Analyzed [*********************************************·····] 😍   91% Table 551 'ANALYTICS.EMPLOYEES_MAILROOM'
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for snowflake Database 5 'Uno Health Analytics' (19.5 ms)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:10-06:00 INFO metabase.sync.util FINISHED: Analyze data for snowflake Database 5 'Uno Health Analytics' (910.7 ms)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:16-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 185.1 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (22 idle, 0 queued) (159 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:26-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 148.0 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 7/50 (20 idle, 0 queued) (158 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:27-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 121.7 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (22 idle, 0 queued) (159 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:27-06:00 DEBUG metabase.server.middleware.log GET /api/health 200 181.7 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (21 idle, 0 queued) (157 total active threads) Queries in flight: 0 (0 queued)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:27-06:00 INFO metabase.sync.util FINISHED: step 'update-field-values' for snowflake Database 5 'Uno Health Analytics' (50.0 s)
[3f057846-cdbd-4a92-8a3e-13644b3a1443] 2024-01-03T10:44:27-06:00 INFO metabase.sync.util FINISHED: Cache field values in snowflake Database 5 'Uno Health Analytics' (51.8 s)
1 Like
2

@unohealth did your version change? For us the issue coincides with a new version - our accounts on v0.47.9 don't have the issue.

3

I think we updated to 0.48.1 around the time this happened, but it's hard to tell with the holidays, and we forgot to back up a previous version. Are you having this issue too?

4

Yup! We have a few accounts. The ones on the new version are having this issue and the ones on the old version aren't.

5

@shai can you check my post in Data Warehouse Schemas not Showing Up - Marking Tables as Inactive - #10 by Luiggi?

1 Like