hcb
hcb8mo ago

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-c8mo 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
hcb8mo 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-c8mo 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
hcb8mo ago
hcb
hcb8mo 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-c8mo 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
hcb8mo ago
👍