I added a few more changes here as I noticed there were still some issues with type inspection

• Adds RedshiftTypeEngine so we can support calling str on custom data types (e.g. SUPER, TIMETZ) (which requires compilation of the type ref).
• Overrides sqlalchemy.sql.type_api.TypeEngine._default_dialect() method to return RedshiftDialectMixin rather than DefaultDialect — as we need access to RedshiftTypeCompiler to successfully compile the type. See sqlalchemy.sql.type_api.TypeEngine.compile

Use case:

from sqlalchemy_redshift.dialect import TIMETZ, SUPER, TIMESTAMPTZ, GEOMETRY

for x in (TIMETZ(), TIMESTAMPTZ(), SUPER(), GEOMETRY()):
    print(x)

TIMETZ
TIMESTAMPTZ
SUPER
GEOMETRY

previous behavior

sqlalchemy.exc.UnsupportedCompilationError: Compiler <sqlalchemy.sql.compiler.GenericTypeCompiler object at 0x7fdd6427e610> can't render element of type <class 'sqlalchemy_redshift.dialect.TIMETZ'> (Background on this error at: http://sqlalche.me/e/l7de)

• Has RedshiftDialectMixin inherit from DefaultDialect so the default dialect initializer is called upon creation of a RedshiftDialectMixin object, so dialect attributes such as type_compiler are initialized. (the use case is the above mentioned type compilation)

• Modifies Redshift data types to inherit from RedshiftTypeEngine so compilation of these types results in the RedshiftDialectMixin being utilized.

• Adds docs for TIMETZ and TIMESTAMPTZ’s unused timezone parameter

• Changes redshift_ischema_names -> REDSHIFT_ISCHEMA_NAMES

I don’t think we can move REDSHIFT_ISCHEMA_NAMES to be defined with the rest of the constants at the top of dialect.py as it makes reference to the Redshift data types (e.g. TIMETZ) which are defined after the constants. I’m open to any suggestions as to where else this constant could live

Feel free to force push the content to the trigger-integration branch of the main repo when you're ready to have integration tests run.

Hmm, I pushed to trigger-integration but encountered some message saying build have been temporarily disabled. I'll pick this PR back up following Thanksgiving week. Enjoy the holiday! :)

but encountered some message saying build have been temporarily disabled

I'll contact Travis support to get this unstuck.

Enjoy the holiday! :)

Likewise!

Thanks for getting Travis going again, @jklukas! Integration tests are all passing. Am I ok to merge?

Looks good! Feel free to merge.