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!
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: