Loading data Vertica to Vertica

You can use COPY with a view, I use it to limit the data we copy to another cluster to one year. The view contains the logic. You can put your select in a view and then use it in the COPY. I have also used the COPY on the same database to build a table rather than doing "insert into table select" (was faster in our case)
CONNECT info here;
COPY TargetSchema.TargetTable from VERTICA database.schema.viewname DIRECT STREAM NAME 'StreamName';
DISCONNECT database;

Show!
Thank you very much.

@scottpedersoli

I am trying to run the following command as per its orientation:

COPY schemaDestination.tableDestination FROM VERTICA databaseName.schemaName.viewName DIRECT;

Except that it returns the following error:

That is, it says that my database does not exist. Would you help me?

I'm not connected using vsql or vertica admin tools. Can I run this command using DBeaver, without having to use "connect" and don't set my user and password?

Are you trying to COPY data from a remote Vertica DB? If so, you have to connect to the remote Vertica DB first, then you run the COPY FROM VERTICA command!

And you can run it from dBeaver:

If you are just copy DATA in the same database, then use an INSERT:

INSERT /*+ DIRECT */ INTO schemaDestination.tableDestination SELECT * FROM schemaName.viewName;

Yes, you can run in dbbeaver. You have to use CONNECT to enable data import (using the COPY FROM VERTICA statement) or export (using the EXPORT statement). Have to do this it this way because you indicated you wanted to use COPY to see in load streams.