Is it a good idea to use COPY LOCAL from DC that is remote to current DC? This will make COPY easy, otherwise I'll first have to copy all the data from remote DC, then load data to Vertica
"DC" == "data center"? I haven't personally tried this myself. But in principle it should be an entirely reasonable thing to do. COPY LOCAL is just establishing a TCP connection and shipping the file data over it. Which is presumably what you'd be doing anyway, using one protocol or another. One potential caveat, COPY LOCAL does not encrypt transmitted data. So there might be security concerns with a direct-over-the-Internet connection. Though, if you're connecting two data centers, hopefully you have a secure VPN solution that you can use.
Comments