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
hey !
the problem is that I created a new table (postgres sql) , and the table is not displayed in retool (the scheme not getting updated) so I can't query it
I tried to add delete the resource and create a new one. nothing works , the old schema keeps showing
This might explain why the query is trying to apply the previous table's schema.
In your first post, you mentioned that your "current Postgres queries have no permission to communicate with the new tables (unless I reference the query to use the new resource)", could you elaborate on what permissions you have applied?
Are you getting an error message when you run the query with the new table specified? Are you using SQL or GUI mode for your Postgres queries?
You should ideally use a single resource for a Postgres DB and use the queries to specify which table.
You might need to regenerate columns for a table component if you are actively switching the tables data source back and fourth between two query sources/tables.
Is the old table's schema showing in the query result that queries the new table?
I need some screen shots to better understand and assist
