Hello again! I have another question - Is it possible to preserve all the schema indexes from the original read data table after ELT is done? Seems like

tap-postgres

removed all indexes except for the primary key. Thank you!

Hi @xinge_li. It's not possible. The Singer spec does not (currently) support metadata on indexes. You can always just add them as part of a downstream transformation step, unless you're only really replicating data

Hi thank you for answering! it is not a problem for us to have one extra step, I was just investigating the possibility 🙂

One a side note I was looking at this for tap-oracle, I have seen multiple key_properties being listed, but that doesn't help you past the primary key. I was debating on hacking something here with a schema key being added for some meta data info. As far as I went but we didn't need it bad enough