I'm using a Vertica SQL client DBVisualizer to run queries on Vertica. I would like to encapsulate my code. I would want users to just enter couple parameters on my queries and get the results.
I read and got 2 options.. 1 UDF's.. since the code returns tables of records and involves temp tables. I don't think it's the feasible option. Am I right?
2> External procedures. viewtopic.php?f=63&t=1329&p=4316&hilit= ... dure#p4316
The above solution shows how to give access to a table. but results of my code change with parameters entered and creating tables every time and giving access to users doesn't seem feasible.
Whats the best way out?