W
Windmill3mo ago
hcb

Database studio doesn't show tables

I'm connected to a supabase, Data studio allows me to see the resource, shows schema and values. BUT doesn't show anything in the tables dropdown. How can I choose a table?
7 Replies
henri-c
henri-c3mo ago
Hi @hcb ! It seems to work on my side with a postgresql resource linked to a Supabase Does your postgresql resource work for a simple Postgresql script ? (like SELECT * FROM table) https://www.windmill.dev/docs/getting_started/scripts_quickstart/sql#postgresql-1
Quickstart PostgreSQL, MySQL, MS SQL, BigQuery, Snowflake | Windmill
In this quick start guide, we will write our first script in SQL. We will see how to connect a Windmill instance to an external SQL service and then send queries to the database using Windmill Scripts.
hcb
hcb3mo ago
Hey, thanks. After refreshing page tables showed. But now after table selection no columns are populating. I'm too much of a noob dev for this I think 🙂
henri-c
henri-c3mo ago
Haha don't worry I'm no dev myself Mmh it seems to work on my side after a few seconds loading Could you send a screenshot of what it looks like in your app ? + Are you on cloud or on a self-hosted instance ?
hcb
hcb3mo ago
hcb
hcb3mo ago
I'm on cloud nevermind... again. Switching tables seems to refresh the data, switching back to the table I want pulled in the columns.
henri-c
henri-c3mo ago
Ok thanks, I'll test if it can happen on my side If the problem persists or makes your app building complicated, please reach out 🙂
hcb
hcb3mo ago
👍