How to create a view using postgres or athena

I am trying to save a view on retool. My resource would be athena.

Hi @neeharika_kusampudi! Could you elaborate a little more on what you'd like to save / your ideal workflow here? And by view, I assume you mean this type of view? 😊

Hey Victoria, I am familiar with a way to create view on AWS athena but I was wondering if I could do the same from Retool interface. Does that make sense?

Definitely possible! I just wrote a query, createProductView to create a view (called 'test') and then wrote another query, query14 to query that view, and it works as expected. :blush: