CODEWITHSUNDEEP
sqlamazon-web-servicesamazon-redshiftvisiolucidchart
Hello lad
Hello lad

Reputation: 18790

Is there a way to generate redshift sql?

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

Upvotes: 1

Views: 297

Answers (1)

John Rotenstein
John Rotenstein

Reputation: 269121

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.

Upvotes: 1

Related Questions