-
Goal: I want my staging environment database to have prepared queries disabled to replicate how production is configured and allow me to test logic that relies on this.
-
Steps: I've tried visiting the database resource settings page, but I can't find any option to do this.
I'm aware of the workaround offered in Unable to disable prepared statements for Retool DB enviroments other than production - set-up the database as a new resource using the connection string, and disable prepared statements on that, but I want to see if there's any other approach as having to switch over the database resource on all my staging apps would not be ideal.
Hello @Nik_Gupta,
Can you share a screen shot of the Resource's advanced options?
I just opened a Postgres resource, switched the environment to staging and was able to toggle the Disable converting queries to prepared statements at the bottom of an existing resource.
Are you self hosting Retool? If so, what version are you on? This might need a feature flag activation if you are on an older version of Retool.
