We have 3 on premises instances of retool, which we are setting up using Github and the protected apps mechanism. We have moved our apps from another git repository across to github, and brought them into a development instance. I am however having problems getting the apps to recognise the resources configured on the new instance, despite them having (apparently) the correct resource names. On the original instance we had a resource called 'Production GIS1 (read)'. Our apps obviously use that name in their queries, and expect it to be there in the new instance. It was configured with that exact name, and in the instance's public.resources table in the underlying postgres DB showed that name in the 'displayName' field.
Unfortunately when I configured the resources on the new instance, including 'Production GIS1 (read)', the apps showed the message 'Could not find Production GIS1 (read). This error might occur if the resource was deleted.' :
Furthermore, the resource dropdown in the app shows those configured resources, but with an ' (postgres)' suffix on the name, that we did not configure:
Why is the query renamed in this way, such that named resources are then not found?
Furthermore, anytime a query has it's resource changed, the query text is lost and must be re-entered. Without a resolution for this, we would have to go in and reconfigure every query in every app that we have created, and rewrite every query's text. This would be a lot of work to say the least.
Is there a simple resolution to this, or a way to export resource configurations from one instance to another? I tried inserting the contents of the public.resources table to the new instance, but this did not seem to be picked up.