I know it exists but i just cant seem to find it under any panel.
Hey @ishaan812! Sorry for the delay in getting back to you, somehow we didn’t get notified about this message. Are you asking how to disable prepared statements for a resource? If so, under the resource setup page, there should be a checkbox that admins can check to disable prepared statements! Let me know if you need any help finding it.
In each Resource configured you will see
as mentioned by @victoria above
1 Like
Is there any way to make another instance of Retool DB as a resource?
I wanted to try disabling this, but am worried that it might affect my usages of the resource.
Edit: I tried "Create New Resource" and clicked Retool DB, but it just links over the the Database page.
Hey @khill-fbmc - I hadn't considered this before, but there definitely is a way to create another resource that points to the same database. Doing so would allow you to disable prepared statements for that resource without affecting your default connection. Do keep in mind the potential impact of this.
You can grab RetoolDB's connection info as shown below and then set up a brand new PostgreSQL resource using that same info. Remember to enable SSL!
Et voilà! You should now have an additional way to access RetoolDB and, furthermore, be able to disable prepared statements for this alternative resource.
1 Like
Of course... I didn't think about doing it that way, thank you!! 
I understand the risks, thank you for pointing it out.
I am only wanting to use it for my own transform and load I am designing in a workflow that has to ingest a messy Excel file.
1 Like