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

I have a BigQuery resource set up with write access to the tables within. I am trying to use the JSON schema form but no tables are populating in the dropdown when I choose my resource (see photo). Has anyone else encountered this? What did you do to resolve? Any insight would be greatly appreciated!

Screen Shot 2021-02-08 at 4.53.46 PM

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