Hi Vaibhav,
1. Inserts speeds are destination dependent. Our current RDBMS all use inserts and aren’t the most efficient. I’m currently overhauling our Redshift destination to use upload to cloud storage + copy which is an order of magnitude faster. We have a
ticket to improve this, and it’s a matter of prioritisation. So let us know a specific warehouse is blocking you.
2. We do not support selecting a subset of columns when replicating a table. Is this what you were thinking of?
3. Yes. We have considered this idea and have this
ticket for tracking, however this honestly isn’t high on our list. Feel free to post on the ticket!
Does this make sense?