New Destination: Vertica

zachwarren4 commented 3 years ago

Tell us about the new connector you’d like to have

Which source and which destination? S3 -> Vertica MongoDB -> Vertica RDS (Postgres) -> Vertica Vertica -> RDS (Postgres)
Do you need a specific version of the underlying data source e.g: you specifically need support for an older version of the API or DB? Vertica 10.0.1

Describe the context around this new connector

Which team in your company wants this integration, what for? This helps us understand the use case. Data Engineering namely, keep our data in sync between multiple sources and avoid complex replication orchestrations
How often do you want to run syncs? Hourly/daily depends on dataset
If this is an API source connector, which entities/endpoints do you need supported?

Describe the alternative you are considering or using

What are you considering doing if you don’t have this integration through Airbyte? Airflow, cron, Python scripts

sherifnada commented 3 years ago

@zachwarren4 thanks for creating the issue! would you be open to contributing Vertica as a DB? The easiest way today would be in java but we can provide python docs once we release the python destination library.

zachwarren4 commented 3 years ago

@sherifnada I would love to but I don't even know where to start!

hrmnjt commented 2 years ago

+1 for this connector.

Please let me know if python destination library is released and I could contribute in python.

airbytehq / airbyte