creating and building design programmatically

avoronin

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.

ybei

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

dprutean

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