Datagrip Vertica Connection - full DDL



We started using a licensed edition of data grip lately in our company.

Our data warehouse db is Vertica and one of our essential needs is to be able viewing full DDL of tables, which contains CRETE TABLE statement, partition clause, and projections creation. However, when generating DDL to the console we only see the CREATE TABLE part, without the rest. 

Is there a way to view the full DDL in Vertica? Do we need to install something to do so?

Thank you,


Data engineer, Outbrain.

Please sign in to leave a comment.