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.

Answers

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.