1

I have a visio .vdx for the design of the my data warehouse with Lucidchart. Is there a way to generate redshift sql from that ?

What would be the best tool to work with Redshift data modeling ?

If those sql generator can generate tables for special visio stencil, like http://www.visualdatavault.com

Hello lad
  • 17,344
  • 46
  • 127
  • 200

1 Answers1

1

Amazon Redshift is (mostly) compatible with PostgreSQL, so any tool that can introspect PostgreSQL tables should work with Redshift.

One things to note -- constraints and foreign keys are not enforced in Redshift.

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
  • Column compression encodings, distkeys and sortkeys are also critical to the schema and probably aren't supported by such tools. – mike_pdb Mar 30 '16 at 07:19