Use any Database to ... flow type to extract data from Vertica, transform it, and load it into any destination. The flow treats Vertica as a regular relational database source.
Build a Reverse ETL flow
- Open Flows and click Add flow.
- In Select Flow Type, type database to and pick the flow type that matches your destination (database, warehouse, file, API, queue, …).
- Set the source connection to your Vertica connection.
- Configure source query, mapping, and any flow parameters as you would for any other database source.
For full coverage of database-as-source patterns, see Extract, Transform, and Load (ETL) data — source is a relational database.