What is the best tool to use for building/maintaining data models for Vertica?
I'm looking for something that will allow me to communicate with my data warehouse team via data modeling. I know what I want the tables to look like for my analysis and dimensional modeling purposes however we need a good way to keep that in sync w/ what has been created already. I've used ERwin in the past but haven't had the best luck with it in recent years. Anyone out there have a good recommendation for a data modeling tool that plays nicely with Vertica?