schemainspect
schemainspect copied to clipboard
djrobstep
Redshift Dialect Support
Hi! I am using schemainspect as the data-collector for a schema comparison tool between a postgres (9.6.9) DB and a Redshift Data Warehouse (which reports as Postgres 8.0.2), so added support for both.
I know this is test-free for now, but wanted to get your opinion before doing any more work on it.
Awesome, thanks so much for writing this. Redshift support will be a great addition.
A little busy at the moment but while find time for a more thorough review when I can.
I've never used redshift myself tho. How easy/hard is it going to be to test this?
No worries. I have been thinking a little about that too, along with handling other Postgres versions. Redshift started its life as Postgres 8, but was taken apart for OLAP (rather than OLTP) workloads. A big part of this was moving from a single DB node to a cluster (and all the partitioning and data distribution clustered configurations involve). So although we can test against vanilla Postgres 8, there is a laundry-list of PG8 features that aren't available in Redshift. So ideally, support for 8 and Redshift should be kept separate. Unhelpfully, SQLAlchemy reports Redshifts dialect as 8, which is why I added an override for RS.
