Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save claudinei-daitx/850ab096902bde616df79572733c6d79 to your computer and use it in GitHub Desktop.
Save claudinei-daitx/850ab096902bde616df79572733c6d79 to your computer and use it in GitHub Desktop.
Schema SPY Redshift configuration file
schemaspy.t=redshift
# Optional path to alternative jdbc drivers.
# Download the last redshift JDBC on https://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver
# In this example, I use the RedshiftJDBC42-1.2.10.1009.jar file.
schemaspy.dp=RedshiftJDBC42-1.2.10.1009.jar
# database properties: host, port number, name user, password
schemaspy.host=<<server_hostname>>
schemaspy.port=<<server_port>>
schemaspy.db=<<database_name>>
schemaspy.u=<<user_name>>
schemaspy.p=<<password>>
# output dir to save generated files
schemaspy.o=<<the_path_to_save_generate_the_files>>
# db scheme for which generate diagrams
schemaspy.s=<<schema_name>>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment