Redshift DB Sync Not Working

When trying to sync db schema for Redshift, nothing is happening. Syncing for Postgres DB is working fine.

From logs - it looks like theres a bug report being fired when I attempt to start sync, but not sure what else I can diagnose from here. I'm able to query the Redshift data without issue, its only the syncs that are failing. I've attempted to grant SUPERUSER permissions to the metabase user and the sync still are not working

[6bdcc4f7-b105-4722-9b0f-4023918d3a26] 2023-11-29T16:14:21-05:00 DEBUG metabase.server.middleware.log POST /api/database/2/sync_schema 200 14.1 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (44 idle, 0 queued) (236 total active threads) Queries in flight: 0 (0 queued); redshift DB 2 connections: 0/15 (0 threads blocked)
[6bdcc4f7-b105-4722-9b0f-4023918d3a26] 2023-11-29T16:14:22-05:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 3.8 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (44 idle, 0 queued) (236 total active threads) Queries in flight: 0 (0 queued)

Facing same issue with Redshift Sync not working. Following.

This was resolved in 0.47.9