The vwload command can be used to load data into a Vector table. It is less flexible but easier to use than COPY and often faster. You can also use vwload to load data in parallel into a single table to further speed up data loads.

For example, the following command loads the data in the lineitem.txt file into the lineitem table of the dbt3 database. In the lineitem table, fields are delimited by | and records are delimited by a new line (\n).

Enter the following command at the operating system prompt:

You can load data from cloud sources such as Amazon S3 (s3a:// and s3n://) using vwload. Specify the full URI for the data files you want to load.

The following example loads the customer table into the mydb database in parallel mode. The source files reside in Amazon S3 cloud storage. Columns in the data file are delimited with a vertical bar. Records are delimited by a new line:

or