Redshift db is not syncing with metabase

I'm using metabase in aws ecs(container model) and using metabase/metabase:latest image[previously i was using metabase/metabase:v0.55.3] and my redshift is serverless. Now the issue is when i add the database in metabase, it's keep on loading but not syncing the databases/tables for very long time. I can see the loading state in admin setting, could you please help me on this @matthewhefferon

Tagging @TonyC for more help

Hi there,

Could you send the logs from Admin > Troubleshooting > Logs during the sync? Do you see any errors?

1 Like

Hi Marcos,

I found out the issue in logs and now redshift is loaded properly in metabase.

Issue: There is one table name called public.Ratecard here public is not schema. Someone has created this table in wrong format and due to this i was getting invalid syntax error.

Action Taken: I dropped this table from redshift and reloaded the connection in metabase, then i worked fine.

Thanks for the help @marcos

1 Like