Hi Madhan,
Thanks for your input, it was very helpful.
Regarding the redshift connector, I have come to the understanding that there is no option available to pass a custom query, which rules out that option. However, I can create a new view and use it to ingest the data. I was just curious to kno...