Page 1 of 1

Encapsulation in Vertica

Posted: Thu Jul 30, 2015 2:42 pm
by Beg1nner
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?