How to create a view using postgres or athena

neeharika_kusampudi · April 29, 2021, 8:42pm

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

victoria · May 4, 2021, 2:40am

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? 😊 https://docs.aws.amazon.com/athena/latest/ug/views.html

neeharika_kusampudi · May 5, 2021, 5:25pm

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?

victoria · May 6, 2021, 11:06pm

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.

victoria · July 28, 2023, 1:47am