Hi All, I tried Airbyte for data ingestion from Redshift to Oracle DB(On-Prem) and I see target table has json data and it took 41mins for 50k rows. As destination is On prem it is taking time right? Or is there any thing to do performance tuning?
n
Nataly Merezhuk (Airbyte)
12/08/2022, 3:35 PM
Hi! Could you please give me bit more info:
1. Airbyte version
2. Connector versions
3. Any sync logs
Thanks!
a
Anand PS
12/08/2022, 5:56 PM
Hi Nataly, Airbyte version: 0.40.22
airbyte/source-redshift:0.3.15
airbyte/destination-oracle:0.1.19
I looked at the logs and your sync speed is as expected 2-3K rows per second. Take a look at this Scaling Airbyte doc, but otherwise looks like the connection is working as expected!
https://docs.airbyte.com/operator-guides/scaling-airbyte
a
Anand PS
12/14/2022, 10:05 AM
how can normalize data instead of json format in oracle db
u
user
12/14/2022, 7:19 PM
Could you please clarify your question? Typically we like to keep to one question per thread to help the team stay organized.