How to update my Retool database from a HubSpot query?

[ScottR]

Yes and you can use a WITH clause... Check out this post:

Retool DB - adding lookup fields from a linked record from a different table

The two fields folderId and name must already be existing columns in the logs table for you to insert them into the logs table. YOu can then use a with clause statement: WITH selected_scenarios AS ( SELECT name, folderId FROM scenarios ) INSERT INTO logs (name, folderId) SELECT name, folderId FROM selected_scenarios;