Redshift Table Discovery

[andresarslanian]

Describe the bug I added a connection to Redshift where I have more than 400 tables. WrenAI connects correctly to Redshift but only sees 41 tables. It has 2 problems:

1. It's not seeing all schemas
2. in the schemas it is seeing, it doesnt see all the tables.

The WrenAI user of Redshift has all the privileges, for example in the schemas that are not being seen marts, candidates or intermediate:

GRANT USAGE ON SCHEMA candidate    TO ROLE wren_readonly;
GRANT USAGE ON SCHEMA marts        TO ROLE wren_readonly;
GRANT USAGE ON SCHEMA intermediate TO ROLE wren_readonly;

GRANT SELECT ON ALL TABLES IN SCHEMA candidate, marts, intermediate TO ROLE wren_readonly;
ALTER DEFAULT PRIVILEGES IN SCHEMA candidate, marts, intermediate
GRANT SELECT ON TABLES TO ROLE wren_readonly;

To Reproduce Steps to reproduce the behavior: Just entered the credentials.

I'm running it in Docker locally.

Expected behavior I would expect to see all the tables. I'm using other apps such as Metabase, with the same credentials I can see all the tables and schemas.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• Mac, Chrome & Safari, running in docker v0.

Wren AI Information

• Version: 0.27.0

Additional context Add any other context about the problem here.

Relevant log output

• Please share config.yaml with us, it should be located at `

config.yaml

`.

wrenai-ibis-server.log wrenai-wren-engine.log wrenai-wren-ai-service.log wrenai-wren-ui.log

[douenergy]

Hi @andresarslanian, thanks a lot for reporting this — it’s a super helpful issue! 🎉 I’ll take a look this week, and if I track down the root cause, I’ll share the details here.

[douenergy]

@andresarslanian I believe I’ve identified the issue — it stems from our Redshift metadata query. The information schema in Redshift differs slightly from that of Postgres. I will prepare a fix and have it ready before next Wednesday.