Vertica to Vertica Load

Vertica to Vertica Load

Vertica provides a way to load data(without creating a file) directly and quickly from table in 1 Vertica cluster to table in other Vertica cluster. This can be accomplished using Vertica's 'CONNECT TO VERTICA'.

VSQL client is needed to load data from one Vertica to other Vertica cluster. This can be downloaded from vertica site at https://www.vertica.com/download/vertica/client-drivers/


Data can be loaded from Vertica to Vertica table following below 4 steps
Other approach to load data
Below command works similar to EXPORT TO VERTICA but it can be used to copy data to current vertica cluster from other instead of export to other.

COPY vertica_cluster_name.schema_name.table_name FROM  VERTICA other_vertica_cluster_name.schema_name.table_name DIRECT;