CI/CD with two env on Vertica
I'm looking for some stuff regarding continuous integration and continuous delivery with two environments on Vertica. Are there any guide could help me?
Regarding DDL and schema speaking, we'll want to use some db migrations software like Flyway + Jenkins.
My biggest worry is about the data, unfortunately we haven't got any pipeline on test environment and the only solution is to bring the data from production every random time, are there any suggestion to achieve this process? keep in mind we are speaking 20+ peta of data.