creating and building design programmatically

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.


  • Options
    dpruteandprutean Community Edition User

    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

    Synchronize Vertica Schema with DbSchema

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file