Hi Israa I suspect you could use the JDBC Source Connector to connect to Redshift. You may also need to play around with the Redshift JDBC driver to get it working. : https://github.com/aws/amazon-redshift-jdbc-driver For clarity, I haven't done this myself but I suspect this would be a reasonable approach.
On Fri, Jun 10, 2022 at 10:08 AM Israa Jaffery <is...@ataloud.com> wrote: > Good Afternoon, > There is a requirement wherein we need to select data from few tables in > AWS redshift fit them into a data model and then transfer it via a > datapipeline to GCP Bigquery. > We are planning to use Apache Kafka and Kafka Connectors as the data > modelling/pipe-lining interface between redshift and bigquery. > Can you please let us know how we can transfer data from Redshift to Kafka > as mostly we got information on how to transfer data from Kafka to Redshift > but not the other way around? > > > Regards, > > Israa Jaffery > Big Data Engineer > 91-7030562393 > > > > > >
