Encapsulation in Vertica

Moderator: NorbertKrupa

Post Reply
Beg1nner
Newbie
Newbie
Posts: 20
Joined: Fri Jul 24, 2015 8:46 pm

Encapsulation in Vertica

Post by Beg1nner » Thu Jul 30, 2015 2:42 pm

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?

Post Reply

Return to “New to Vertica SQL”