Goal: Get the latest tables to be available on retool's UI
Steps: I refreshed the schema , also tried to copy the resource , nothing works , the only way I can see the new tables is when creating the resources from scratch, then the schema gets refreshed.
along with this issue , my current Postgres queries have no permission to communicate with the new tables (unless I reference the query to use the new resource)
it's important to say that the old and new resource are communicating with the same Postgres db
what should I do in order to force refresh the resource tables, sequences etc..
thanks!
So it sounds like you are looking to use a Query to display a table from a Database Resource into a Table Component, is that correct?
Could you elaborate more on the schema refreshing? A database's schema should be standard and not change, it sounds like you are working with multiple tables and each table has a different schema, is that correct?
Could you share a screen shot of the query you are using and the new/old resources you are using?
It sounds like you are looking for a way to dynamically change which table is being queried, as currently in the GUI for a Postgres query users must manually select the table by name which they are fetching
