- Follow the instructions in http://schemaspy.readthedocs.io/en/latest/installation.html to install schemaspy
- Get the redshift jdbc driver from http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html
- Modify the sample config file with your params
- run java -jar schemaspy-6.0.0-rc1.jar -configFile schemaspy.cfg
- If you get " Can't find bundle for base name org/schemaspy/types/redshift ..." download the properites file from https://raw.githubusercontent.com/schemaspy/schemaspy/master/src/main/resources/org/schemaspy/types/redshift.properties and add "-t redshift.properties" to the command
Last active
July 10, 2024 21:53
-
-
Save drorm/14ca3ac50d90cada44fa1d8f0e121bd1 to your computer and use it in GitHub Desktop.
schemaspy for redshift
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # type of database. Run with -dbhelp for details | |
| schemaspy.t=redshift | |
| # optional path to alternative jdbc drivers. | |
| schemaspy.dp=./RedshiftJDBC42-1.2.7.1003.jar | |
| # database properties: host, port number, name user, password | |
| schemaspy.host=xxxxx.yyyy.eu-west-1.redshift.amazonaws.com | |
| schemaspy.port=5439 | |
| schemaspy.db=test | |
| schemaspy.u=test | |
| schemaspy.p=*************** | |
| # output dir to save generated files | |
| schemaspy.o=schemaspy | |
| # db scheme for which generate diagrams | |
| schemaspy.s=public |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This is very helpful, thank you for writing it!