How can I get my database tables to populate in JSON schema form?

Hi @kd27! Welcome to the community! :sunglasses:

A couple things you can look into:

If not, Retool is likely either not able to fetch the schema from your resource or it's failing to do so. You can check in the devtools of the browser and see if this request is actually successful and returning results:

You should also see this query being called when you open the generate schema modal (it might be cached if you've already tried to run it). But if that query is returning a 200 status code but no results, Retool is likely unable to find the schema due to the regional qualifier of the data:

If the region is incorrect, you'll still be able to query data but it won't be able to fetch the dataset's metadata.

Hopefully this helps! & let me know what you find

2 Likes