Hello, I have some experience of creating and deploying designs on vertica.
But I have a question - is there a way to create and build design programmatically. But this I mean: run a query to collect certain queries from query repository and then run command to build a design from this collection.
Question
creating and building design programmatically
+1
Are you using the "designer_" API to run the design ?
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/DatabaseDesigner/DatabaseDesignerFunctions.htm?tocpath=SQL Reference Manual|SQL Functions|Vertica Meta-Functions|Database Designer Functions|_____0
There are some tools which can help you for this. Look at DbSchema client and designer for Vertica. It has two features which are interesting for you:
- They load their own image of the schema, separate from the database. This means you have a model which you can manage local
- You can use Groovy or JS to modify the model from the SQL Editor. This means you can have a Groovy script running directly in DbSchema, read information from some queries, etc, and use the results to modify the DbSchema design directly
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
