Options

creating and building design programmatically

avoroninavoronin ✭
in General Discussion

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.

Best Answer

Answers

  • 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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...